Re: Restricting the capability of ODBC users

Ross,

I do not know how you could configure the ODBC drivers, however there may be another way:

1. Create two roles in Oracle ( v7.0 +). One role has only select privilege to the objects (e.g. R_SELECT). The second role was select, insert and update privileges ( R_ALL).
2. Grant the appropiate privileges to the roles.
3. Revoke all object privileges from the users.
4. Grant both the roles to the users, making the R_SELECT the default role.
5. When the users access the db through Excel etc. they can log into Oracle as usual, however update, insert authority will be blocked by the RDBMS.
6. In your application, issue the following command as the first statement 'SET ROLE R_ALL;'
7. After this during this session the users will have all update, insert authority.

Hope this helps.

Vikram Goel

Sr. DBA

MOTOROLA - Byonton Beach, Florida

email: vgoel_at_emi.net Received on Tue Oct 31 1995 - 00:00:00 CET