Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: User table privs ,roles and system privileges

Re: User table privs ,roles and system privileges

From: Brian Peasland <dba_at_nospam.peasland.net>
Date: Thu, 15 Mar 2007 13:04:09 -0500
Message-ID: <45f97e17$0$16294$88260bb3@free.teranews.com>


Massa Batheli wrote:
> Would need help formating the user privs ,roles and table privs on a
> per user bases
>
> I know the tables to query but would need help properly formatting the
> information into the different categories
>
> like
>
> ROLES
>
> dba
>
> PRIVILEGES
>
> unlimited tablespace
>
> TABLES
> select on batheli.dog
> update on batheli.cat
>
> Any input is greatly appreciated as usual
>
>
> Massa
>

This information is found in the DBA_ROLE_PRIVS, DBA_SYS_PRIVS and DBA_TAB_PRIVS views.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

-- 
Posted via a free Usenet account from http://www.teranews.com
Received on Thu Mar 15 2007 - 13:04:09 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US