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

_____________________________________________________________________________________________________________________

Website Stats