Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Grants
On Mon, 21 Sep 1998 17:34:39 +0200, "Josef Huber"
<josef.huber_at_ennstal.at> wrote:
>Hello,
>
>Is there a view where i can see to what tables,views,sequences the user has
>access ?
ALL_TABLES, ALL_VIEWS, ALL_SEQUENCES.... If you want to list those objects to which user has access but are owned by somebody else, include the following condition in the query: "... WHERE owner != user".
>Ciao,
>Joe
Regards,
--
Jurij Modic <jmodic_at_src.si>
Certified Oracle7 DBA (OCP)