Re: DBA TABLES visible via ODBC

From: Thomas Olszewicki <ThomasO_at_cpas.com>
Date: Fri, 05 Nov 1999 15:02:07 GMT
Message-ID: <PjCU3.31923$At1.239579_at_news1.rdc2.on.home.com>


Peter,
Oracle Database doesn't know where are you connecting from (ACCESS or SQL/Plus), nor what tool are you using to connect (OCI,ODBC,ADO) . Visibilty of DBA,ALL,USER view is resolved based on user privliages. You can always access USER views.
You can access DBA view if you are connecting as user with DBA role privs. HTH
Thomas Olszewicki
ThomasO_at_cpas.com
www.cpas.com Received on Fri Nov 05 1999 - 16:02:07 CET

Original text of this message