Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: select username,tablename,privilege?
select grantee, table_name, privilege from all_tab_privs where table_schema
= 'MYSCHEMA';
"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 Mon Sep 11 2000 - 09:37:49 CDT