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, 1465🔥, 0💬
Popular Posts:
How To Convert Numeric Expression Data Types using the CONVERT() Function in SQL Server Transact-SQL...
How To Convert Numeric Values to Integers in SQL Server Transact-SQL? Sometimes you need to round a ...
What is SQL Server Transact-SQL (T-SQL)? SQL Server Transact-SQL, also called T-SQL, is an extension...
Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for...
What Is the Difference Between GETDATE() and GETUTCDATE() in SQL Server Transact-SQL? The difference...