Database Administration (MOSC)

MOSC Banner

How to identified the begin user session using "THROUGH connection" ?

edited Apr 3, 2014 12:00PM in Database Administration (MOSC) 2 commentsAnswered

How to identified the begin user session using "THROUGH connection" ?

for example i have next:

create user a  identified by "a" ;

create user b  identified by "b" ;

alter user a GRANT CONNECT THROUGH b;

I can Connect

b[a]/b@Database

but i need  identified user connection through "b" user. In the next select only see "a" user. i need know a user through by "b", how to do it

SELECT s.*

FROM   gv$session s

       JOIN gv$process p ON p.addr = s.paddr AND p.inst_id = s.inst_id

WHERE  s.type != 'BACKGROUND' and s.USERNAME='a';

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center