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
how many tables will create when we create table, what are they? : Sql dba
What is the difference between functions, procedures, and packages in pl/sql?
What is the difference between a primary key and a unique key?
what is a database lock ? : Sql dba
Is sql a microsoft product?
What is the meaning of disabling a trigger?
What is difference between procedure and trigger?
how to show all tables with 'mysql'? : Sql dba
explain what is mysql? : Sql dba
What are pl sql procedures?
Explain the advantages and disadvantages of stored procedure?
How many unique keys can a table have?
What are the various levels of constraints?
How do I view an execution plan in sql?
What is trigger in sql?