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

From: Michael Serbanescu <mserban_at_postoffice.worldnet.att.net>
Date: 1997/08/09
Message-ID: <33EBFEC9.448D@postoffice.worldnet.att.net>#1/1

USER_TABLES contains _only_ information about the table(s) the user _owns_, i.e. the table(s) (s)he _created_. So, it looks like your user has not created any tables. Have the user try:

SELECT * from dba_tables; (as an example)

Hope this helps.

Michael Serbanescu

---

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
  Received on Sat Aug 09 1997 - 00:00:00 CDT