Answers

Question and Answer:

  Home  Oracle Database

⟩ What Privilege Is Needed for a User to Create Views in Oracle?

To 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.

 176 views

More Questions for you: