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 -> User table privs ,roles and system privileges

User table privs ,roles and system privileges

From: Massa Batheli <mngong_at_gmail.com>
Date: 15 Mar 2007 09:54:23 -0700
Message-ID: <1173977663.786880.291090@l77g2000hsb.googlegroups.com>


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 Received on Thu Mar 15 2007 - 11:54:23 CDT

Original text of this message

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