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 timestamp in mysql? : Sql dba
Can a composite key be null?
What is the max nvarchar size?
What is data manipulation language?
Why sql query is slow?
What are inner outer left and right joins in sql?
Define the select into statement.
Lookups are a key component in sql server integration services (ssis). Explain its purpose?
what does the t-sql command ident_current does? : Transact sql
What are sql objects?
Is it possible to create the following trigger: before or after update trigger for each row?
Explain the difference between cursor declared in procedures and cursors declared in the package specification?
how to get a list of all tables in a database? : Sql dba
what is oltp (online transaction processing)? : Sql dba
What are analytical functions in sql?