what is the difference between granting and creating a view?
Answers were Sorted based on User's Feedback
Answer / prasuna
Granting view means giving access to the view that is
already created where as creating a view means creating a
new view
granting privileges to a view is a dcl command
where as creating a view is a ddl command
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / swapna
Granting depends upon the user, he may give permission for
others to manipulation on the table. But in case of views
others can only retrive the table.
granting is dcl command
creating is ddl command
Is This Answer Correct ? | 1 Yes | 1 No |
What are the types of join and explain each?
What is pls_integer in pl sql?
Why triggers are used?
How many rows can sqlite handle?
How to write pl sql program in mysql command prompt?
what are the type of locks ? : Sql dba
How many aggregate functions are available there in sql?
what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba
explain access control lists. : Sql dba
How do you determine the current isolation level? : Transact sql
how to create object in plsql
What is the use of sqldataadapter?