Oracle9i Database Reference
Release 1 (9.0.1)

Part Number A90190-02
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go to next page

Static Data Dictionary Views, 375 of 521


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. Oracle Corporation recommends that you do not use this view.

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 


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback