Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
What Privilege Is Needed for a User to Create Views
What Privilege Is Needed for a User to Create Views? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges
✍: 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.
2007-05-01, 4611👍, 0💬
Popular Posts:
How can you enable automatic paging in DataGrid ? Following are the points to be done in order to en...
What is the benefit of using an enum rather than a #define constant? The use of an enumeration const...
How will you freeze the requirement in this case? What will be your requirement satisfaction criteri...
How To Set Up Breakpoints in Debug Mode? - Oracle DBA FAQ - Introduction to Oracle SQL Developer To ...
If we inherit a class do the private variables also get inherited ? Yes, the variables are inherited...