Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between granting and creating a view?
- 2 Answers
- 6308 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / prasuna
Granting view means giving access to the view that is
already created where as creating a view means creating a
new view
granting privileges to a view is a dcl command
where as creating a view is a ddl command
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / 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 |
Can we use commit or rollback in trigger? If yes, then how. Please explain with a suitable example?
What is rename in sql?
how can we destroy the cookie? : Sql dba
Is sqlite thread safe?
How to export the table data (this table having 18 million records) to .csv file. Please tell me is there any faster way to export the data.
Do triggers have restrictions on the usage of large datatypes, such as long and long raw?
What is difference between cursor and ref cursor?
suppose I have two table one Emp and other is dpt. Emp table has a field ,dept id,name ,sal and dpt table has a field dept id,dept name. Now I want to find out the emplyee list whose sal is between 2000-3000 from dept x.
7 Answers Geometric Software, IBM,
Can function return multiple values in sql?
What makes a good primary key?
how to saw triggers output in pl/sql database?
What is orm in sql?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
