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

Home -> Community -> Usenet -> c.d.o.tools -> Setting ODBC user priveleges

Setting ODBC user priveleges

From: Darryl <dfs_at_nospam.com>
Date: Sun, 11 Mar 2001 09:15:34 GMT
Message-ID: <WmHq6.622$6p5.64639@newsread1.prod.itd.earthlink.net> 






When I use ODBC to link to an Oracle database (say through MS Access), I can
see all schemas/objects in the instance.  How can I restrict my Oracle
configuration so ODBC users see only the objects in one (or more) schemas?



I've been messing around with GRANTing and REVOKEing the PRIVELEGE values in
DBA_TAB_PRIVS, and I'm getting closer, but I don't really know what I'm
doing.



Thanks,


Darryl
Received on Sun Mar 11 2001 - 03:15:34 CST












Original text of this message













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