Collections:
Privilege to Insert Rows in Another Schema in Oracle
What Privilege Is Needed for a User to Insert Rows to Tables in Another Schema in Oracle?
✍: 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.
⇒ Privilege to Delete Rows in Another Schema in Oracle
⇐ Privilege to Query Tables in Another Schema in Oracle
2019-06-11, 1557🔥, 0💬
Popular Posts:
How To Convert Numeric Values to Character Strings in MySQL? You can convert numeric values to chara...
Where to find SQL Server Transact-SQL language references? You can find SQL Server Transact-SQL lang...
How To Drop a Stored Procedure in Oracle? If there is an existing stored procedure and you don't wan...
How To Convert Characters to Numbers in Oracle? You can convert characters to numbers by using the T...
What Is "mysqld" in MySQL? "mysqld" is MySQL server daemon program which runs quietly in background ...