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 the different index configurations a table can have? : Sql dba
How to pipe multiline string to isql?
Can we write dml inside a function in sql server?
What is pl sql in dbms?
What is substitution variable in pl sql?
what is cursor. write example of it. What are the attributes of cursor.
what are date and time data types? : Sql dba
how to drop an existing table in mysql? : Sql dba
What are aggregate functions in sql?
Why we use pl sql?
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
Lookups are a key component in sql server integration services (ssis). Explain its purpose?
What is the purpose of cursors in pl/sql?
What is pl sql record in oracle?
Can I call a procedure inside a function?