Re: HELP: users granted SELECT ANY TABLE can't select any table

From: Mike Morgan <mmorga2_at_amfam.com>
Date: 1997/08/08
Message-ID: <01bca440$f053b090$7c38c8a5@mxm014pc>#1/1

John,

The USER_TABLES view lists the tables you own (i.e. those you created). The ALL_TABLES view includes your tables along with those to which you have been granted access. Also, unless you there is a synonym for the tables owned by someone else, you will need to reference them with the schema name as well. (e.g. SCOTT.EMP)

(The ALL_TABLES view includes a column for OWNER. This is the schema you will reference.)

Mike Morgan

H. John C. Hopkins <john_at_hpe.ufl.edu> wrote in article <01bca414$46f517e0$d335e380_at_john.hpe.ufl.edu>...
> The title says it all.
>
> I've given some of my Oracle7 server users the SELECT ANY TABLE system
> privelege and they can't select ANY tables (put another way, "select *
from
> user_tables" returns "no rows selected" when logged in as those users).
I
> even created a Test user with the CONNECT and SELECT ANY TABLE
privileges.
> No good.
>
> Why the heck would this happen?
>
> Confused,
> John
>
>
Received on Fri Aug 08 1997 - 00:00:00 CDT