Re: select username,tablename,privilege?

From: Nascar <nascar_at_flash.net>
Date: Sat, 09 Sep 2000 15:45:30 GMT
Message-ID: <uWsu5.806$oc3.77553@news.flash.net>

user_tab_privs
table_privileges

Actually, your best bet is to select * From dict; (I think that is it) and it will give you a list of the data dictionary views and their uses. After this, begin reading some more Oracle manuals. It's tough to keep on top of things - but at least if you read through a couple, you might know where to look the next time.

"Russell England" <russ_at_css2.com> wrote in message news:%k7u5.12186$yG4.1203171_at_news1.cableinet.net...
> Is it possible to
>
> select username, tablename, privilege
> from *somewhere*
> where schema = 'myschema'
>
> Cheers
>
> Russ
>
>
Received on Sat Sep 09 2000 - 10:45:30 CDT