what is the difference between granting and creating a view?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Enlist the data types that can be used in pl/sql?

747


How is use pl and sql?

735


How do temporal tables work?

692


How do I quit sql?

684


Is sql scripting language?

725






Describe types of sql statements?

722


What has stored procedures in sql and how we can use it?

764


What are the types of index in sql?

771


what is transaction? : Sql dba

719


What are the different datatypes available in PL/SQL?

754


what are the advantages and disadvantages of cascading style sheets? : Sql dba

801


What is server name sql?

801


What is primary key and foreign key?

716


How do you take the union of two tables in sql?

731


What is trigger explain it?

738