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

_____________________________________________________________________________________________________________________

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
  1. 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

_____________________________________________________________________________________________________________________

0 comments:

Post a Comment

 

acehints.com Copyright 2011-17 All Rights Reserved | Site Map | Contact | Disclaimer | Google