Home » RDBMS Server » Security » who is the actual user ??
who is the actual user ?? [message #179650] Wed, 28 June 2006 05:32 Go to next message
aggiridharan
Messages: 3
Registered: June 2006
Junior Member
IF any user is connected as sysdba, then the user is shown as "SYS";
1.How to find out who the actual user , connected as sysdba ?

2. What is the query to know what all users are connected, what time the connection was established to a db and how long ??
Re: who is the actual user ?? [message #179654 is a reply to message #179650] Wed, 28 June 2006 05:43 Go to previous message
aciolac
Messages: 242
Registered: February 2006
Senior Member
1) You can connect by ANY username(any string) to database:
>sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Jun 28 13:42:33 2006

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL> connect as sysdba
Enter user-name: qaw
Enter password:
Connected to an idle instance.
SQL>

So, I think that it is generally impossible to see what user-name was introduced, because generally so username can to be unexistent in database. When You are connect as SYSDBA, Oracle simply opens SYS session.

2)All information what you are need are in the v$session.
Previous Topic: Remote login without password
Next Topic: Audit in Oracle
Goto Forum:
  


Current Time: Fri Mar 29 05:00:45 CDT 2024