1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

what is the difference between granting and creating a view?

Question Posted / swapna

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 datatypes a available in PL/SQL ?

2 Answers  

How do I copy a table in sql?

0 Answers  

What are the types of triggers in sql?

0 Answers  

Difference between NVL, NVL2 and NULLIF

1 Answers   CTS, Metric Stream,

What is compilation error in pl sql?

0 Answers  




In packages the source code is compiled into p code ? how do we describe the p code

3 Answers  

Give which cursor is better for better performance means type of cursors?

2 Answers  

What is bulk collections?

2 Answers  

Is a foreign key always unique?

0 Answers  

What is full join?

0 Answers  

how to create a new view in mysql? : Sql dba

0 Answers  

Can we use delete in merge statement?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories