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
how to concatenate two character strings? : Sql dba
Describe types of sql statements?
What is sql server and ase?
What is the usage of sql functions?
What is int identity in sql?
What's the difference between a primary key and a clustered index?
What is mutating sql table?
what is the difference between union and union all? : Sql dba
How many parts of a pl sql block are optional?
What is materialized view in sql?
how to install mysql? : Sql dba
What are % type and % rowtype?
how to create a new view in mysql? : Sql dba
What is information schema in sql?
What is scope of pl sql developer in future?