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

You need to prefix the table name by its schema name For eg select * from schema.table_name;
These tables will be present in all_tables and not user_tables since the user doesn't own them.
In other words try select * from all_tables

Gautham

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 Mon Aug 11 1997 - 00:00:00 CDT