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>
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