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, 1659🔥, 0💬
Popular Posts:
How To Convert Numeric Expression Data Types using the CONVERT() Function in SQL Server Transact-SQL...
How To Select All Columns of All Rows from a Table with a SELECT statement in SQL Server? The simple...
Where to find answers to frequently asked questions on Storage Engines: MyISAM, InnoDB and BDB in My...
How to run Queries with SQL Server Management Studio Express in SQL Server? 1. Launch and connect SQ...
How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want t...