Static Data Dictionary Views, 327 of 452

TABLE_PRIVILEGES

TABLE_PRIVILEGES contains information on grants on objects for which the user is the grantor, grantee, or owner, or PUBLIC is the grantee. This view is included for compatibility with Oracle version 6. Use of this view is not recommended.

Column Datatype NULL Description

GRANTEE

VARCHAR2(30)

NOT NULL

Name of the user to whom access is granted

OWNER

VARCHAR2(30)

NOT NULL

Owner of the object

TABLE_NAME

VARCHAR2(30)

NOT NULL

Name of the object

GRANTOR

VARCHAR2(30)

NOT NULL

Name of the user who performed the grant

SELECT_PRIV

VARCHAR2(1)

Permission to select from the object

INSERT_PRIV

VARCHAR2(1)

Permission to insert into the object

DELETE_PRIV

VARCHAR2(1)

Permission to delete from the object

UPDATE_PRIV

VARCHAR2(1)

Permission to update the object

REFERENCES_PRIV

VARCHAR2(1)

Permission to reference the object

ALTER_PRIV

VARCHAR2(1)

Permission to alter the object

INDEX_PRIV

VARCHAR2(1)

Permission to create or drop an index on the object

CREATED

VARCHAR2(0)

Timestamp for the grant

Column	Datatype	NULL	Description
`GRANTEE`	`VARCHAR2(30)`	`NOT NULL`	Name of the user to whom access is granted
`OWNER`	`VARCHAR2(30)`	`NOT NULL`	Owner of the object
`TABLE_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the object
`GRANTOR`	`VARCHAR2(30)`	`NOT NULL`	Name of the user who performed the grant
`SELECT_PRIV`	`VARCHAR2(1)`		Permission to select from the object
`INSERT_PRIV`	`VARCHAR2(1)`		Permission to insert into the object
`DELETE_PRIV`	`VARCHAR2(1)`		Permission to delete from the object
`UPDATE_PRIV`	`VARCHAR2(1)`		Permission to update the object
`REFERENCES_PRIV`	`VARCHAR2(1)`		Permission to reference the object
`ALTER_PRIV`	`VARCHAR2(1)`		Permission to alter the object
`INDEX_PRIV`	`VARCHAR2(1)`		Permission to create or drop an index on the object
`CREATED`	`VARCHAR2(0)`		Timestamp for the grant