I tried to implement database security in a VB application using Oracle
Database in the following manner:
I've developed an application using ODBC to access an Oracle Database.
First of all, I called a stored procedure that gives the current user
the privilege to query a table. Then, I queried that table to see if the
privilege was really granted to me. But, unfortunately, it didn't work.
Afterwards, I did the same thing using Oracle Objects. This time I was
successful. My conclusion was that ODBC doesn't support the concept of
real sessions. Each command seems to be completely independent.
I'd like to know if anyone else had experienced this problem.
Thanks in advance.