Collections:
Privilege to Delete Rows in Another Schema in Oracle
What Privilege Is Needed for a User to Delete Rows from Tables in Another Schema in Oracle?
✍: FYIcenter.com
For a user to delete rows from tables of someone else's schema, he/she needs the DELETE ANY TABLE privilege. The following tutorial exercise gives you a good example of granting "dev" to delete rows in "hr" schema:
>.\bin\sqlplus /nolog SQL> CONNECT DEV/developer SQL> DELETE FROM hr.jobs WHERE job_id = 'DV.FYI'; ORA-01031: insufficient privileges SQL> disconnect SQL> connect SYSTEM/fyicenter SQL> GRANT DELETE ANY TABLE TO dev; Grant succeeded. SQL> disconnect SQL> CONNECT DEV/developer SQL> DELETE FROM hr.jobs WHERE job_id = 'DV.FYI'; 1 row deleted.
As you can see, "dev" can delete rows in any schema now. But you should be careful when giving this privilege to a regular developer.
⇒ Show Privileges of the Current User in Oracle
⇐ Privilege to Insert Rows in Another Schema in Oracle
2019-06-11, 1527🔥, 0💬
Popular Posts:
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...
How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers a...
How To Assign Debug Privileges to a User in Oracle? In order to run SQL Developer in debug mode, the...
How to change the data type of an existing column with "ALTER TABLE" statements in SQL Server? Somet...
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...