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 is the difference between join and union? : Sql dba
What is compute?
Are stored procedures compiled?
how to enter characters as hex numbers? : Sql dba
how to drop an existing index in mysql? : Sql dba
If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????
Which join is like an inner join?
Is like operator in sql case sensitive?
What does subquery mean in sql?
How many sql statements are used? Define them.
What is indexes?
What are triggers and its uses?
what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba
Can we use loop in sql?
What is pl sql variable?