Re: Sequences and Roles

From: Venkatesh Krishnan <rishnan_at_condor.mbcr.bcm.tmc.edu>
Date: 1997/08/30
Message-ID: <34082A48.356A@condor.mbcr.bcm.tmc.edu>#1/1

mfu wrote:
>
> >
> > Richard J Woodland wrote:
> > >
 

> > > How can I find out which roles are associated with a particular entity
> > > (in this case, a sequence), so that I might be able to recover them
> > > after a drop/create operation.
> >
>
> In order to see roles for entities other than your own userid,
> you must have DBA authority. Role information may be found
> in tables:
> DBA_ROLES
> DBA_ROLE_PRIVS
> Only users with DBA auth may (re)grant entity authorizations.
MFU, Try, select grantee

     sys.dba_tab_privs
     where table_name = 'SEQUENCE NAME'.

This will give you grants given to all users/roles, for the sequence/object.

The following will give all the roles that the object has been granted privilege

     select grantee
     sys.dba_tab_privs a, sys.dba_roles b
     where a.grantee = b.role
     and table_name = 'SEQUENCE NAME'.

Sridhar Subramaniam Received on Sat Aug 30 1997 - 00:00:00 CDT