Suppose I have to create a view on a table, that is not yet been
created by DBA. I khow the table structure. Is it possible to
create the view before DBA creates this table? If yes then how?
Is it possible to create synonym in this way?
- 4 Answers
- 11882 Views
- IBM, Metric Stream, I also Faced
- E-Mail Answers
Answer Posted / ram
i cannot create a view unless the DBA gives me create view system privilege and to create a view in any schema, rather than just your own we need the create view privilege and be granted the select,insert,update and delete objects on table underlying the view.
synonym is the alias to database object and to hide details of source of the database object. a public synonym is created by the DBA and is available for use by any database user. a private synonym is defined in the schema by the user and is available to the user.
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
what are the t string functions available in tsql? : Transact sql
Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?
What problem one might face while writing log information to a data-base table in pl/sql?
How do I find duplicates in two columns?
what are the 'mysql' command line options? : Sql dba
how would you get the current date in mysql? : Sql dba
Is pl sql and postgresql same?
What is a full join sql?
What is sql scripting?
How does postgresql compare to mysql?
What is set transaction?
What's the difference between inner join and left join?
What is crud stand for?
how to drop an existing view in mysql? : Sql dba
Is t sql a programming language?
