Oracle8i Reference
Release 2 (8.1.6)

A76961-01

Library

Product

Contents

Index

Prev Up Next

Static Data Dictionary Views, 312 of 452


ROLE_TAB_PRIVS

ROLE_TAB_PRIVS contains information about table privileges granted to roles. Information is provided only about roles to which the user has access.

Column  Datatype  NULL  Description 

ROLE 

VARCHAR2(30) 

NOT NULL 

Name of the role 

OWNER 

VARCHAR2(30) 

NOT NULL 

Owner of the object 

TABLE_NAME 

VARCHAR2(30) 

NOT NULL 

Name of the object 

COLUMN_NAME 

VARCHAR2(30) 

 

Name of the column, if applicable 

PRIVILEGE 

VARCHAR2(40) 

NOT NULL 

Object privilege granted to the role 

GRANTABLE 

VARCHAR2(3) 

 

YES if the role was granted with ADMIN OPTION; otherwise NO 


Prev Up Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index