Select privilege... hitting the database
We are linking to an Oracle 8 database via an Access table (an Access97 .mdb table linked to an Oracle table and used from VB6).
This is hitting the Oracle database (according to the Oracle Buffer Gets) heavily with the following SQL:
Select privilege#, level from sysauth$ connect by grantee#=prior privilege# and privelege#>0 start with (grantee#=:1 or grantee#=1) and privilege#>0
We are not issuing this SQL instruction directly, but it is being raised somehow.
We are connecting via the Microsoft ODBC for Oracle driver.
What is causing this problem?