userenv('ISDBA') : To check the Current Oracle Session has DBA Privilege

advertisements

_____________________________________________________________________________________________________________________

USERENV provides the current oracle session details. Userenv(‘ISDBA’) will give you true or false information whether your session has SYSDBA privilege through operating system or a password file.

Please find some example on the same.

1. Connected as normal user

SQL>  CONNECT APPINSTALL@PROD

Enter password:

Connected.

SQL> SELECT userenv('ISDBA'),  SYS_CONTEXT( 'USERENV', 'AUTHENTICATION_METHOD' ) AUTHENTICATION FROM DUAL;

USEREN AUTHENTICA

------ ----------

FALSE  PASSWORD

2. Connected as sysdba user

SQL> CONNECT APPINSTALL@PROD as sysdba

Enter password:

Connected.

SQL> SELECT userenv('ISDBA'),  SYS_CONTEXT( 'USERENV', 'AUTHENTICATION_METHOD' ) AUTHENTICATION FROM DUAL;

USEREN AUTHENTICA

------ ----------

TRUE   PASSWORD

SQL> connect / as sysdba

Connected.

SQL> SELECT userenv('ISDBA'),  SYS_CONTEXT( 'USERENV', 'AUTHENTICATION_METHOD' ) AUTHENTICATION FROM DUAL;

USEREN AUTHENTICA

------ ----------

TRUE   OS

_____________________________________________________________________________________________________________________

Live Traffic Feed

A visitor from Sariyer viewed 'Fix ORA-01927: cannot REVOKE privileges you did no' 15 mins ago

A visitor from St louis viewed 'Purpose of ORAENV_ASK=NO / YES variable in Oracle' 40 mins ago

A visitor from Chennai viewed 'Purge AWR Snapshots Manually from Oracle Database' 42 mins ago

A visitor from Navi mumbai viewed 'Explicit Vs Implicit Commit in Oracle– Difference ' 45 mins ago

A visitor from Kansas city viewed 'How to Find out / Check SGA and PGA size of Oracle' 54 mins ago

Real-time | Get Script | More Info