what is the difference between granting and creating a view?
- 2 Answers
- 5610 Views
- I also Faced
- E-Mail Answers
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 tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba
What are the sql commands?
How do I write a sql query in pgadmin 4?
What is sqlite used for?
What is an implicit commit?
How many commands are there in sql?
What are the different set operators available in sql?
What is the left table in sql?
Can we write dml inside a function in sql server?
Does sql view stored data?
when MSQL8.0 is in market
How to check if a column is nullable before setting to nullable?
What is a memo field?
What is embedded sql what are its advantages?
Is hadoop a nosql?
