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


TABLE: SYS.SYSAUTH$

Object Details
Object Name: SYSAUTH$
Object Type: TABLE
Owner: SYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Indexes
Index Type Uniqueness Tablespace Column
I_SYSAUTH1 NORMAL UNIQUE TablespaceSYSTEM ColumnGRANTEE#
ColumnPRIVILEGE#
Columns
Name Datatype Length Mandatory Comments
GRANTEE# NUMBER
Yes
PRIVILEGE# NUMBER
Yes
SEQUENCE# NUMBER
Yes
OPTION$ NUMBER

Query Text

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


SELECT GRANTEE#
,      PRIVILEGE#
,      SEQUENCE#
,      OPTION$
FROM SYS.SYSAUTH$;

Dependencies

[top of page]

SYS.SYSAUTH$ does not reference any database object

SYS.SYSAUTH$ is referenced by following:

SchemaCTXSYS
Package BodyDRIACC - show dependent code
SchemaDVSYS
ViewDBA_DV_USER_PRIVS
ViewDBA_DV_USER_PRIVS_ALL
SchemaOLAPSYS
ViewALL$OLAP_COLUMNS
ViewALL$OLAP_FOREIGN_KEYS
ViewALL$OLAP_FUNCTION_ARGUMENTS
ViewALL$OLAP_KEYS
ViewALL$OLAP_KEY_COLUMN_USES
ViewALL$OLAP_TABLES
Package BodyCWM$UTIL - show dependent code
Package BodyCWM2$SECURITY - show dependent code
Package BodyCWM2_OLAP_VERIFY_ACCESS - show dependent code
SchemaSYS
ViewALL_DEPENDENCIES
ViewALL_ERRORS
ViewALL_ERRORS_AE
ViewALL_IDENTIFIERS
ViewALL_JAVA_ARGUMENTS
ViewALL_JAVA_CLASSES
ViewALL_JAVA_DERIVATIONS
ViewALL_JAVA_FIELDS
ViewALL_JAVA_IMPLEMENTS
ViewALL_JAVA_INNERS
ViewALL_JAVA_LAYOUTS
ViewALL_JAVA_METHODS
ViewALL_JAVA_NCOMPS
ViewALL_JAVA_RESOLVERS
ViewALL_JAVA_THROWS
ViewALL_REFRESH
ViewALL_REFRESH_CHILDREN
ViewALL_SOURCE
ViewALL_SOURCE_AE
ViewALL_STORED_SETTINGS
ViewALL_TRIGGER_COLS
ViewALL_WARNING_SETTINGS
ViewDBA_ROLE_PRIVS
ViewDBA_RSRC_MANAGER_SYSTEM_PRIVS
ViewDBA_SYS_PRIVS
ViewDBA_XS_ROLE_GRANTS
Package BodyDBMS_CUBE_ADVISE_SEC - show dependent code
Package BodyDBMS_PRIV_CAPTURE - show dependent code
Package BodyDBMS_ZHELP - show dependent code
ViewEXPEXEMPT
ViewEXU7RLG
ViewEXU7SPV
ViewEXU8FPTU
ViewEXU8RLG
ViewEXU8SPV
ViewEXU8TYPTU
ViewEXU92FPTPU
ViewEXU92FPTU
ViewEXU9TYPTU
ViewEXU9TYPTU2
ViewIMP8TTDU
ViewKU$_ROGRANT_VIEW
ViewKU$_SYSGRANT_VIEW
ViewORA_KGLR7_DEPENDENCIES
ViewORA_KGLR7_IDL_CHAR
ViewORA_KGLR7_IDL_SB4
ViewORA_KGLR7_IDL_UB1
ViewORA_KGLR7_IDL_UB2
ViewROLE_ROLE_PRIVS
ViewROLE_SYS_PRIVS
ViewROLE_TAB_PRIVS
ViewUSER_JAVA_POLICY
ViewUSER_ROLE_PRIVS
ViewUSER_RSRC_MANAGER_SYSTEM_PRIVS
ViewUSER_SYS_PRIVS