
Query read-only connection with ODBC using DAO?
Is this possible?
I have a VB app which connects to an Oracle database through ODBC using
DAO. I am using Intersolv's ODBC drivers. I have a login screen where the
user enters an Oracle userid and password to sign on. Since Oracle has the
capability of assigning 'read-only' userids, I was wonder if, after I make
the connection, there was a way I can query the Connection object (or
something else) to find out the user has read-only access.
What I'd like to do is disable some screen fields if the user connects with
a read-only userid. I am quite certain doing this would be much easier if
I had used the ODBC API, but since I am using DAO I am wondering if anyone
has tried this or has any recommendations.
By the way, the flag you can specify while opening a connection which
indicates the connection should be read-only *does not* work. You are
still allowed to make updates. Even if it did, I'd rather query the DAO
object to see if the user is connected read-only as opposed to hard-coding
a special userid into my login screen that will make a read-only connection
explicitly.
--
Regards,
Jim