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

Home -> Community -> Usenet -> c.d.o.server -> Re: Who has what rights on tables they do not own.

Re: Who has what rights on tables they do not own.

From: Hans Forbrich <forbrich_at_yahoo.net>
Date: Mon, 13 Sep 2004 19:21:50 GMT
Message-ID: <irm1d.3905$XP3.1926@edtnps84>


Tyler Smith Watu wrote:

> I like sql to be able to get all tables that users have rights to in
> the database but which they do not own.
> Preferably NOT by entering the user name each time as a result of &
>
> TIA
> TY

9iR2?

http://www.oracle.com/pls/db92/db92.docindex?remark=homepage >> Reference
>> {

    ALL_TAB_PRIVS
    ALL_TAB_PRIVS_MADE
    ALL_TAB_PRIVS_RECD

   } Received on Mon Sep 13 2004 - 14:21:50 CDT

Original text of this message

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