OraFAQ Forum: Security » how am I to know that I have logged in not as SYSDBA???

Home » RDBMS Server » Security » how am I to know that I have logged in not as SYSDBA???

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how am I to know that I have logged in not as SYSDBA??? [message #297165]

Wed, 30 January 2008 07:26

prajjwal
Messages: 28
Registered: January 2008
Location: kolkata

Junior Member

After changing the parameter O7_DICTIONARY_ACCESSIBILITY to true, I can log in as SYS without (as sysdba) or (as sysoper)...

From sqlplus

SQL> show user
USER is "SYS"

At any later stage how am I to know that I have logged in not as SYSDBA???

Report message to a moderator

Re: how am I to know that I have logged in not as SYSDBA??? [message #297168 is a reply to message #297165]

Wed, 30 January 2008 07:52

Frank Naude
Messages: 4572
Registered: April 1998

Senior Member

It's recorded in sys.v$session_connect_info:

SQL> conn sys/oracle
Connected.
SQL> SELECT DISTINCT(authentication_type) FROM v$session_connect_info WHERE sid = USERENV('SID');

AUTHENTICATION_TYPE
--------------------------
DATABASE

SQL> conn / as sysdba
Connected.
SQL> /

AUTHENTICATION_TYPE
--------------------------
INTERNAL

PS: O7_DICTIONARY_ACCESSIBILITY should be set to FALSE for better security.

Report message to a moderator