what is the difference between granting and creating a view?
Answer Posted / 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 View All Answers
What are different types of functions in sql?
Can I create table without primary key?
What is Histogram?
Can we create view in stored procedure?
How do I send sql query results to excel?
what are the performance and scalability characteristics of mysql? : Sql dba
Is left join faster than inner join?
What is group function in sql?
What is the purpose of using pl/sql?
What is acid property in a database?
What is record type in pl sql?
what is datawarehouse? : Sql dba
How to test for null values?
what is cursor. write example of it. What are the attributes of cursor.
How do I count records in sql?