Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between granting and creating a view?
- 2 Answers
- 6155 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 are pl sql data types?
how to remove records from table? no name 1 a 2 b 1 a 2 b 3 c
What is the difference between SQL Constraint and PL/SQL constraint.Pls give all the constraint name.
What is bind variable in pl sql?
How do you take the union of two tables in sql?
what are different types of collation sensitivity? : Sql dba
What is difference between stored procedure and trigger?
I have the table like this S.No Name ID 01 Xyz 123 I want the result as 01Xyz123 How to write the query to retrieve the entire row data in a single column?
What is bulk collections?
What are the different parts of a package?
Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?
Which normal form is best?
-
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)
