[Home] [Help]
[Dependency Information]
VIEW: SYS.USER_SYS_PRIVS
Object Details
Object Name: | USER_SYS_PRIVS |
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
System privileges granted to current user
[View Source]
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
USERNAME |
VARCHAR2 |
(128) |
|
User Name or PUBLIC |
PRIVILEGE |
VARCHAR2 |
(40) |
|
System privilege |
ADMIN_OPTION |
VARCHAR2 |
(3) |
|
Grant was with the ADMIN option |
COMMON |
VARCHAR2 |
(3) |
|
Privilege was granted commonly |
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT USERNAME
, PRIVILEGE
, ADMIN_OPTION
, COMMON
FROM SYS.USER_SYS_PRIVS;
Dependencies
[top of page]
SYS.USER_SYS_PRIVS references the following:
-
SYS
-
SYSAUTH$
-
SYSTEM_PRIVILEGE_MAP
-
USER$
SYS.USER_SYS_PRIVS is referenced by following:
-
PUBLIC
-
USER_SYS_PRIVS
-
SYS
-
DBMS_EDITIONS_UTILITIES
- show dependent code
-
DBMS_STATS
- show dependent code