Collections:
Show Privileges of the Current User in Oracle
How To Find Out What Privileges a User Currently Has in Oracle?
✍: FYIcenter.com
Privileges granted to users are listed in two system views: DBA_SYS_PRIVS, and USER_SYS_PRIVS. You can find out what privileges a user currently has by running a query on those views as shown in the tutorial exercise below:
>.\bin\sqlplus /nolog SQL> CONNECT DEV/developer SQL> SELECT username, privilege FROM USER_SYS_PRIVS; USERNAME PRIVILEGE ------------------------------ ---------------------- DEV SELECT ANY TABLE DEV INSERT ANY TABLE DEV CREATE SESSION DEV CREATE VIEW DEV DELETE ANY TABLE DEV CREATE ANY TABLE SQL> disconnect SQL> connect SYSTEM/fyicenter SQL> GRANT DELETE ANY TABLE TO dev; Grant succeeded. SQL> SELECT GRANTEE, PRIVILEGE FROM DBA_SYS_PRIVS WHERE GRANTEE = 'HR'; GRANTEE PRIVILEGE ------------------------------ ----------------------- HR CREATE VIEW HR UNLIMITED TABLESPACE HR DEBUG CONNECT SESSION HR CREATE DATABASE LINK HR CREATE SEQUENCE HR CREATE SESSION HR DEBUG ANY PROCEDURE HR ALTER SESSION HR CREATE SYNONYM
Looks like "hr" has move privileges than "dev".
⇒ Managing Oracle Database Tables
⇐ Privilege to Delete Rows in Another Schema in Oracle
2019-06-11, 4692🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions on Storage Engines: MyISAM, InnoDB and BDB in My...
How Fixed Length Strings Are Truncated and Padded in SQL Server Transact-SQL? When the length of the...
What Happens If the UPDATE Subquery Returns Multiple Rows in SQL Server? If a subquery is used in a ...
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...
How To Fix the INSERT Command Denied Error in MySQL? The reason for getting the "1142: INSERT comman...