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
How can we link a sql database to an existing android app?
How to install oracle sql developer?
What is the difference between delete and truncate statement in sql?
What are tuples in sql?
How can you save or place your msg in a table?
what are all the common sql function? : Sql dba
How do I know if I have sql express or standard?
What does select top 1 do in sql?
What is raw datatype in sql?
Can you have a foreign key without a primary key?
What is a sql driver?
how to enter numeric values as hex numbers? : Sql dba
Can we call dml statement in function?
what is timestamp in mysql? : Sql dba
How can triggers be used for the table auditing?