Interview Questions Answers.ORG
Interviewer And Interviewee Guide
Interviews
Quizzes
Home
Quizzes
Interviews DB Oracle Interviews:Concepts and ArchitectureData AccessDatabase ArchitectureDatabase ManagementDatabase Security OracleDistributed ProcessingFlexfieldForms ReportsGeneral OracleMemory ManagementMTO-SAP Financial AccountingOCIOracle AOLOracle AROracle Backup RecoveryOracle D2KOracle DatabaseOracle Database DeveloperOracle DB OptimizationOracle DBAOracle DeveloperOracle ETLOracle Forms 3.0Oracle Forms 4.0Oracle GLOracle PL-SQLOracle RMANOracle ScenariosOracle SecurityOracle SQLOracle System ArchitectureOracle Technology Network (OTN)Programmatic ConstructsRAC (Real Application Clusters)SQL Plus
Copyright © 2018. All Rights Reserved
Oracle Database Interview Question:
How To Find Out What Privileges a User Currently Has in Oracle?
Submitted by: AdministratorPrivileges 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:
>.insqlplus /nolog
SQL> CONNECT DEV/developer
SQL> SELECT username, privilege FROM USER_SYS_PRIVS;
<pre>USERNAME PRIVILEGE
------------------------------ ----------------------
DEV SELECT ANY TABLE
DEV INSERT ANY TABLE
DEV CREATE SESSION
DEV CREATE VIEW
DEV DELETE ANY TABLE
DEV CREATE ANY TABLE</pre>
SQL> disconnect
SQL> connect SYSTEM/globalguideline
Submitted by: Administrator
>.insqlplus /nolog
SQL> CONNECT DEV/developer
SQL> SELECT username, privilege FROM USER_SYS_PRIVS;
<pre>USERNAME PRIVILEGE
------------------------------ ----------------------
DEV SELECT ANY TABLE
DEV INSERT ANY TABLE
DEV CREATE SESSION
DEV CREATE VIEW
DEV DELETE ANY TABLE
DEV CREATE ANY TABLE</pre>
SQL> disconnect
SQL> connect SYSTEM/globalguideline
Submitted by: Administrator
SQL> GRANT DELETE ANY TABLE TO dev;
Grant succeeded.
SQL> SELECT GRANTEE, PRIVILEGE FROM DBA_SYS_PRIVS
WHERE GRANTEE = 'HR';
<pre>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</pre>
Looks like "hr" has move privileges than "dev".
Submitted by: Administrator
Grant succeeded.
SQL> SELECT GRANTEE, PRIVILEGE FROM DBA_SYS_PRIVS
WHERE GRANTEE = 'HR';
<pre>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</pre>
Looks like "hr" has move privileges than "dev".
Submitted by: Administrator
Copyright 2007-2024 by Interview Questions Answers .ORG All Rights Reserved.
https://InterviewQuestionsAnswers.ORG.
https://InterviewQuestionsAnswers.ORG.