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, 1454🔥, 0💬
Popular Posts:
What are single-byte character string data types supported in SQL Server Transact-SQL? Single-byte c...
What Happens If the UPDATE Subquery Returns Multiple Rows in MySQL? If a subquery is used in a UPDAT...
How to download and install Microsoft .NET Framework Version 2.0 in SQL Server? .NET Framework Versi...
How To Convert Binary Strings into Hexadecimal Character Strings in SQL Server? When a query returns...
How To Break Query Output into Pages in MySQL? If you have a query that returns hundreds of rows, an...