Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between granting and creating a view?
- 2 Answers
- 6299 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 |
What is the order of sql select?
How we can update the view?
What is Overloading of procedures ?
Define SQL and state the differences between SQL and other conventional programming Languages?
Is there a 64 bit version of ssms?
What is your daily office routine?
What is cursor in pl sql with examples?
What is coalesce sql?
Does mysql_real_escape_string prevent sql injection?
How does one load ebcdic data? : aql loader
Tell me what a package consists of.
What are % type and % rowtype?
-
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)
