Collections:
Privilege to Create Views in Oracle
What Privilege Is Needed for a User to Create Views in Oracle?
✍: FYIcenter.com
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:
>.\bin\sqlplus /nolog SQL> CONNECT DEV/developer SQL> CREATE VIEW fyi_view AS SELECT * FROM fyi; ORA-01031: insufficient privileges SQL> disconnect SQL> connect SYSTEM/fyicenter SQL> GRANT CREATE VIEW TO dev; Grant succeeded. SQL> disconnect SQL> CONNECT DEV/developer SQL> CREATE VIEW fyi_view AS SELECT * FROM fyi; View created. SQL> DROP VIEW fyi_view; View dropped. SQL> CREATE VIEW fyi_view AS SELECT * FROM fyi; View created.
As you can see, "dev" can create and drop views now.
⇒ Privilege to Create Indexes in Oracle
⇐ Assign a Tablespace to a User in Oracle
2019-06-29, 1670🔥, 0💬
Popular Posts:
How to change the data type of an existing column with "ALTER TABLE" statements in SQL Server? Somet...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...
How To Update Multiple Rows with One UPDATE Statement in SQL Server? If the WHERE clause in an UPDAT...
How To Fix the INSERT Command Denied Error in MySQL? The reason for getting the "1142: INSERT comman...
How to run Queries with SQL Server Management Studio Express in SQL Server? 1. Launch and connect SQ...