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

From: John Blackburn <jdblack_at_qdot.qld.gov.au>
Date: 1997/08/12
Message-ID: <33F0B5DD.12A3@qdot.qld.gov.au>#1/1

H. John C. Hopkins wrote:
>
> 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

USER_TABLES only shows tables OWNED by the user whereas the SELECT ANY TABLE system privelege allows a user to access any table. Try ALL_TABLES If there aren't any public synonyms for the tables you are trying to access, you will have to explicitly specify the schema which owns the table ie:

SELECT * from scott.emp; Received on Tue Aug 12 1997 - 00:00:00 CDT