Skip to Main Content

Breadcrumb

Question and Answer

Chris Saxon

Thanks for the question, Dejan.

Asked: March 27, 2020 - 9:56 am UTC

Answered by: Chris Saxon - Last updated: March 27, 2020 - 4:58 pm UTC

Category: Database Administration - Version: 12.1.0.2

Viewed 100+ times

You Asked

Where in v$ views is hiding info about PROXY_USERNAME ?
I'am aware of little piece of information in v$session_connect_info and dbproxy_username column in unified_audit_trail.
Most appropriate place will be in v$session, but i didn't find it.

Regards Dejan


and we said...

DBA_PROXIES shows you details of the current proxy sessions:

create user u identified by u;
alter user chris grant connect through u;

conn u[chris]/u

select * from dba_proxies;

PROXY    CLIENT    AUTHENTICATION    AUTHORIZATION_CONSTRAINT               ROLE      PROXY_AUTHORITY   
U        CHRIS     NO                PROXY MAY ACTIVATE ALL CLIENT ROLES    <null>    DATABASE           

and you rated our response

  (1 rating)

Reviews

Active connected proxy sessions

March 27, 2020 - 10:47 am UTC

Reviewer: A reader

Thanks for prompt answer.
This is dictionary data of proxy users also available in dba_proxies, but I am searching this dbproxy_username info for currently connected sessions.

Regards dejan
Chris Saxon

Followup  

March 27, 2020 - 4:58 pm UTC

Sorry, missed that. I'm not sure if that information is (easily) available. I'll ask around.

More to Explore

Security

All of the vital components for a secure database are covered in the Security guide.