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 Insert Rows to Tables in Another Schema
What Privilege Is Needed for a User to Insert Rows to Tables in Another Schema? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges
✍: FYIcenter.com
For a user to insert rows into tables of someone else's schema, he/she needs the INSERT ANY TABLE privilege. The following tutorial exercise gives you a good example of granting "dev" to insert rows in "hr" schema:
>.\bin\sqlplus /nolog SQL> CONNECT DEV/developer SQL> INSERT INTO hr.jobs VALUES ('DV.FYI', 'Dev FYI Consultant', 7700, 8800); ORA-01031: insufficient privileges SQL> disconnect SQL> connect SYSTEM/fyicenter SQL> GRANT INSERT ANY TABLE TO dev; Grant succeeded. SQL> disconnect SQL> CONNECT DEV/developer SQL> INSERT INTO hr.jobs VALUES ('DV.FYI', 'Dev FYI Consultant', 7700, 8800); 1 row created.
As you can see, "dev" can insert rows in any schema now. But you should be careful when giving this privilege to a regular developer.
2007-05-01, 4585👍, 0💬
Popular Posts:
How Can we change priority & what levels of priority are provided by Dot Net? Thread Priority ca...
What Is Paint Shop Pro? - PSP Tutorials - Fading Images to Background Colors with PSP Paint Shop Pro...
Can one execute dynamic SQL from Forms? Yes, use the FORMS_DDL built-in or call the DBMS_SQL databas...
What Is a LABEL Tag/Element? - XHTML 1.0 Tutorials - Understanding Forms and Input Fields A "label" ...
What is the quickest sorting method to use? The answer depends on what you mean by quickest. For mos...