Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 12934 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
Why use stored procedures?
What is trigger types in sql?
Why do we need unique key in a table?
what are ddl statements in mysql? : Sql dba
How do I count rows in sql?
Explain the structure of pl/sql in brief.
Can we rename a column in the output of sql query?
What is group by in sql?
How many types of tables are there?
What is a pragma statement?
What is data types in sql?
What is the difference between syntax error and runtime error?
What is Difference Between Unique and Primary Key Constraints?
what is the syntax used for partition in tsql? : Transact sql
how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba
