Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> HELP: users granted SELECT ANY TABLE can't select any table

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

From: H. John C. Hopkins <john_at_hpe.ufl.edu>
Date: 1997/08/08
Message-ID: <01bca414$46f517e0$d335e380@john.hpe.ufl.edu>#1/1 







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












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US