Brian Peasland wrote:
> eAddict wrote:
>> I was asked how to verify what tables, privs, and such a particular
>> oracle user had.
>> Short of showing the scripts I used to create the user, how do I
>> actually go back in
>> and verify/list all rights and to what?
>>
>> Thanks in advance...
>>
>
> The user will have full rights to everything they own. So query
> DBA_OBJECTS to see that user's objects.
>
> The user will have any privileges granted to that user through a role.
> So find out what roles that user has been granted by querying
> DBA_ROLE_PRIVS.
>
> Once you know the roles, you can see any system privileges for that user
> by querying DBA_SYS_PRIVS where the GRANTEE is the user and the user's
> roles. You can see the object-level privileges for that user by querying
> DBA_TAB_PRIVS as well.
>
> HTH,
> Brian
It is also possible to grant rights on a column by column basis so also
check dba_col_privs.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Tue Feb 27 2007 - 17:48:43 CST
