Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Find Out What Privileges a User Currently Has
How To Find Out What Privileges a User Currently Has? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges
✍: 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".
2007-05-01, 5330👍, 0💬
Popular Posts:
Does there exist any other function which can be used to convert an integer or a float to a string? ...
How To Create an Array in PL/SQL? - Oracle DBA FAQ - Introduction to PL/SQL If you want create an ar...
How To Download and install PSP Evaluation? - PSP Tutorials - Fading Images to Background Colors wit...
Can we use the constructor, instead of init(), to initialize servlet? Yes , of course you can use th...
How can I search for data in a linked list? Unfortunately, the only way to search a linked list is w...