Identifying proxied user sessions [message #501660] |
Wed, 30 March 2011 08:12 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8944 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
I'm sure you are all familiar with proxy users, they've been around since 9i:
orcl> create user low identified by low;
User created.
orcl> create user high identified by high;
User created.
orcl> grant dba to high;
Grant succeeded.
orcl> alter user high grant connect through low;
User altered.
orcl> connect low[high]/low
Connected.
orcl> sho user
USER is "HIGH"
orcl>
Is there any way that I can find out which of the current sessions was proxied, and through what user? I know that from within the session I can query my userenv context and find out, but I can't see how to do it otherwise. It must be possible: the audit trail records both the real user and the proxy user.
|
|
|
|
|
|