Re: User table privs ,roles and system privileges

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Thu, 15 Mar 2007 18:00:27 +0100
Message-ID: <45f97baa$0$10412$426a74cc@news.free.fr>

"Massa Batheli" <mngong_at_gmail.com> a écrit dans le message de news: 1173977663.786880.291090_at_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
|

There is no difficulty on these SQL queries. What part stops you?

Maybe if you post what you already thought or done. And your Oracle version.

Regards
Michel Cadot Received on Thu Mar 15 2007 - 12:00:27 CDT