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, 1572🔥, 0💬
Popular Posts:
What Is the Difference Between GETDATE() and GETUTCDATE() in SQL Server Transact-SQL? The difference...
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...
How To Generate CREATE TABLE Script on an Existing Table in SQL Server? If you want to know how an e...
What Are the Differences between DATE and TIMESTAMP in Oracle? The main differences between DATE and...
How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to ...