[Home] [Help] [Dependency Information]

TABLE: SYS.HS$_GRANTED_USERS

Object Details

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Primary Key: HS$_GRANTUSER_PK

1. USER_ID

Unique Key: HS$_GRANTUSER_UK1

1. FDS_INST_ID
2. GRANTEE_NAME

Indexes

Index	Type	Uniqueness	Tablespace	Column
HS$_GRANTUSER_PK	NORMAL	UNIQUE	SYSTEM	USER_ID
HS$_GRANTUSER_UK1	NORMAL	UNIQUE	SYSTEM	FDS_INST_ID GRANTEE_NAME

Foreign Keys

Table		Foreign Table	Foreign Key Column
HS$_GRANTED_USERS		HS$_FDS_INST	HS$_GRANTED_USERS FDS_INST_ID
HS$_ACCESS_GRANTEES		HS$_GRANTED_USERS	HS$_ACCESS_GRANTEES USER_ID
HS$_CREATE_GRANTEES		HS$_GRANTED_USERS	HS$_CREATE_GRANTEES USER_ID

Columns

Query Text

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

SELECT USER_ID
,      FDS_INST_ID
,      GRANTEE_NAME
FROM SYS.HS$_GRANTED_USERS;

Dependencies

[top of page]

SYS.HS$_GRANTED_USERS does not reference any database object

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