What Privilege Is Needed for a User to Create Views in Oracle?
Submitted by: AdministratorTo be able to create views in a user's own schema, the user needs to have the CREATE VIEW privilege, or the CREATE ANY VIEW privilege, which is more powerful, and allows the user to create views in other user's schema. The following tutorial exercise gives you a good example on CREATE VIEW privilege:
>.insqlplus /nolog
SQL> CONNECT DEV/developer
SQL> CREATE VIEW ggl_view AS SELECT * FROM ggl;
ORA-01031: insufficient privileges
SQL> disconnect
SQL> connect SYSTEM/globalguideline
SQL> GRANT CREATE VIEW TO dev;
Grant succeeded.
SQL> disconnect
SQL> CONNECT DEV/developer
SQL> CREATE VIEW ggl_view AS SELECT * FROM ggl;
View created.
SQL> DROP VIEW ggl_view;
View dropped.
SQL> CREATE VIEW ggl_view AS SELECT * FROM ggl;
View created.
As you can see, "dev" can create and drop views now.
Submitted by: Administrator
>.insqlplus /nolog
SQL> CONNECT DEV/developer
SQL> CREATE VIEW ggl_view AS SELECT * FROM ggl;
ORA-01031: insufficient privileges
SQL> disconnect
SQL> connect SYSTEM/globalguideline
SQL> GRANT CREATE VIEW TO dev;
Grant succeeded.
SQL> disconnect
SQL> CONNECT DEV/developer
SQL> CREATE VIEW ggl_view AS SELECT * FROM ggl;
View created.
SQL> DROP VIEW ggl_view;
View dropped.
SQL> CREATE VIEW ggl_view AS SELECT * FROM ggl;
View created.
As you can see, "dev" can create and drop views now.
Submitted by: Administrator
Read Online Oracle Database Job Interview Questions And Answers
Top Oracle Database Questions
☺ | How To Recover a Dropped Table in Oracle? |
☺ | How To Use "OUT" Parameter Properly? |
☺ | How To Invoke the Data Pump Import Utility? |
☺ | What Happens to Indexes If You Drop a Table? |
☺ | What Happens If Variable Names Collide with Table/Column Names? |
Top DB Oracle Categories
☺ | Oracle PL-SQL Interview Questions. |
☺ | Oracle DBA Interview Questions. |
☺ | Oracle D2K Interview Questions. |
☺ | OCI Interview Questions. |
☺ | Forms Reports Interview Questions. |