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?
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 is identity column in sql server?
What are the three pl sql block types?
How to sort the rows in sql.
what is the difference between blob and text? : Sql dba
What are the different operators available in sql?
What is the use of partition by in sql?
Explain the difference between 'between' & 'and' operators in sql
Can you skip header records while loading? : aql loader
Mention what is the plv (pl/vision) package offers?
What are tables in sql?
What is sql performance tuning?
What are all the common sql functions?
Explain clause in sql?
How does sql*loader handles newline characters in a record? : aql loader
What is cascade in sql?