Oracle8i Reference
Release 2 (8.1.6)

Part Number A76961-01

Library

Product

Contents

Index

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

Static Data Dictionary Views, 414 of 452


USER_ROLE_PRIVS

USER_ROLE_PRIVS lists roles granted to the user.

Column  Datatype  NULL  Description 

USERNAME 

VARCHAR2(30) 

 

Name of the user, or PUBLIC 

GRANTED_ROLE 

VARCHAR2(30) 

 

Name of the role granted to the user 

ADMIN_OPTION 

VARCHAR2(3) 

 

Granted with ADMIN option: YES | NO 

DEFAULT_ROLE 

VARCHAR2(3) 

 

Role is designated as the user's default role: YES | NO 

OS_GRANTED 

VARCHAR2(3) 

 

Granted by the operating system: Y/N (occurs if configuration parameter OS_ROLES = TRUE


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

All Rights Reserved.

Library

Product

Contents

Index