Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: select username,tablename,privilege?

Re: select username,tablename,privilege?

From: Mike Dwyer <dwyermj_at_co>
Date: Mon, 11 Sep 2000 08:37:49 -0600
Message-ID: <hc6v5.88$eZ6.10473@wdc-read-01.qwest.net>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US