[Home] [Help] [Dependency Information]

TABLE: SYS.HS$_PRIVILEGES

Object Details

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Primary Key: HS$_PRIV_PK

1. PRIV_ID

Unique Key: HS$_PRIV_UK1

1. PRIV_NAME

Indexes

Index	Type	Uniqueness	Tablespace	Column
HS$_PRIV_PK	NORMAL	UNIQUE	SYSTEM	PRIV_ID
HS$_PRIV_UK1	NORMAL	UNIQUE	SYSTEM	PRIV_NAME

Foreign Keys

Table		Foreign Table	Foreign Key Column
HS$_ACCESS_GRANTEES		HS$_PRIVILEGES	HS$_ACCESS_GRANTEES PRIV_ID
HS$_CREATE_GRANTEES		HS$_PRIVILEGES	HS$_CREATE_GRANTEES PRIV_ID

Columns

Query Text

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

SELECT PRIV_ID
,      PRIV_NAME
,      CREATE_ACCESS_TYPE
FROM SYS.HS$_PRIVILEGES;

Dependencies

[top of page]

SYS.HS$_PRIVILEGES does not reference any database object

SYS.HS$_PRIVILEGES is not referenced by any database object