[Home] [Help] [Dependency Information]

TABLE: SYS.HS$_ACCESS_GRANTEES

Object Details

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Unique Key: HS$_ACCGRANT_UK1

1. EXTOBJ_ID
2. USER_ID
3. PRIV_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
HS$_ACCGRANT_UK1	NORMAL	UNIQUE	SYSTEM	EXTOBJ_ID USER_ID PRIV_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
HS$_ACCESS_GRANTEES		HS$_EXTERNAL_OBJECTS	HS$_ACCESS_GRANTEES EXTOBJ_ID
HS$_ACCESS_GRANTEES		HS$_GRANTED_USERS	HS$_ACCESS_GRANTEES USER_ID
HS$_ACCESS_GRANTEES		HS$_PRIVILEGES	HS$_ACCESS_GRANTEES PRIV_ID

Columns

Query Text

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

SELECT EXTOBJ_ID
,      USER_ID
,      PRIV_ID
FROM SYS.HS$_ACCESS_GRANTEES;

Dependencies

[top of page]

SYS.HS$_ACCESS_GRANTEES does not reference any database object

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