Re: User table privs ,roles and system privileges

"Keith" <kknauss_at_gmail.com> a écrit dans le message de news: 1173979365.294323.43290_at_l77g2000hsb.googlegroups.com... On Mar 15, 1:00 pm, "Michel Cadot" <micadot{at}altern{dot}org> wrote:
> "Massa Batheli" <mng..._at_gmail.com> a écrit dans le message de news: 1173977663.786880.291..._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

I have a proc program to reverse engineer the create user ddl. Email me if you're interested (kknauss at gmail dot com). I don't know if it'll port to your system, but maybe it'll be a starting point.

No need of a Pro*C program to do something you can do with a couple of SQL statements.

Regards
Michel Cadot Received on Thu Mar 15 2007 - 12:59:11 CDT