what is the difference between granting and creating a view?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is an intersect?

643


I need a function for a train ticket reservation please answer it thanks in advance

559


What are the most important ddl statements in sql?

565


what is primary key? : Sql dba

508


What is difference between pl and sql?

526






Is primary key clustered index?

513


What are the possible values that can be stored in a boolean data field?

509


how to delete an existing column in a table? : Sql dba

548


What is the difference between inner join and natural join?

501


What is the cause of mutating table error and how can we solve it?

593


What is trigger in flip flop?

512


Can 2 queries be executed simultaneously in a distributed database system?

636


What is the difference between function, procedure and package in pl/sql?

556


What is a field in a database?

566


what is single byte over head in oracle..?

1862