what is the difference between granting and creating a view?

Answers were Sorted based on User's Feedback



what is the difference between granting and creating a view?..

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

what is the difference between granting and creating a view?..

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

Post New Answer

More SQL PLSQL Interview Questions

What are the types of join and explain each?

0 Answers  


What is pls_integer in pl sql?

0 Answers  


Why triggers are used?

0 Answers  


How many rows can sqlite handle?

0 Answers  


How to write pl sql program in mysql command prompt?

0 Answers  






what are the type of locks ? : Sql dba

0 Answers  


How many aggregate functions are available there in sql?

0 Answers  


what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba

0 Answers  


explain access control lists. : Sql dba

0 Answers  


How do you determine the current isolation level? : Transact sql

0 Answers  


how to create object in plsql

3 Answers   Microsoft,


What is the use of sqldataadapter?

0 Answers  


Categories