DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.PROXY_ROLES

Object Details
Object Name: PROXY_ROLES
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Table of roles that a proxy can set on behalf of a client

[View Source]

Columns
Name Datatype Length Mandatory Comments
PROXY VARCHAR2 (128) Yes Name of a proxy user
CLIENT VARCHAR2 (128) Yes Name of the client user who the proxy user acts as
ROLE VARCHAR2 (128) Yes Name of the role that the proxy can execute
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PROXY
,      CLIENT
,      ROLE
FROM SYS.PROXY_ROLES;

Dependencies

[top of page]

SYS.PROXY_ROLES references the following:

SchemaSYS
TablePROXY_ROLE_INFO$
TableUSER$
SYS.PROXY_ROLES is referenced by following:

SchemaPUBLIC
SynonymPROXY_ROLES
SchemaSYS
ViewPROXY_USERS_AND_ROLES