| who is the actual user ?? [message #179650] |
Wed, 28 June 2006 05:32  |
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  |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
