Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between granting and creating a view?
- 2 Answers
- 6382 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 cost in sql execution plan?
Explain cursor types?
Why partition by is used in sql?
Differences between UNIQUE and DISTINCT in select statements
26 Answers ABS, DELL, Deloitte, Hewitt, Oracle, Verinon Technology Solutions, Wipro,
What has stored procedures in sql and how we can use it?
What does select count (*) mean in sql?
package specification-3 procedures package body-2 procedures will is execute
What is application trigger?
What is Raise_application_error ?
Can we join more than 2 tables in sql?
Are dml statements autocommit?
What are the parts of a basic sql query?
-
Oracle (3253) - 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)
