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
What is substitution variable?
Write a unique difference between a function and a stored procedure.
What is 19 null in sql?
Inline the values in PL/SQL, what does it mean.?
How do you determine the current isolation level? : Transact sql
what is sql in mysql? : Sql dba
How do I view an execution plan in sql?
Define implicit and explicit cursors.
Which is faster subquery or join?
What will you get by the cursor attribute sql%rowcount?
explain the advantages and disadvantages of stored procedure? : Sql dba
What is difference between procedure and trigger?
how to load data files into tables with 'mysqlimport'? : Sql dba
How can I make sql query run faster?
What is difference between rank () row_number () and dense_rank () in sql?