On Mar 15, 1:59 pm, "Michel Cadot" <micadot{at}altern{dot}org> wrote:
> "Keith" <kkna..._at_gmail.com> a écrit dans le message de news: 1173979365.294323.43..._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
Depends on what your application is for... I have it, so I offered.
But, alas...
Received on Thu Mar 15 2007 - 13:02:31 CDT
