Limit db access to users using Access or Toad

[chikkodi]

Here is what I want to do -

When users login to the db using Microsoft Access or Toad, I want to make the data readonly for them.

Here is what I tried doing -

1. Created a role with a readonly privilege. Assign the role using dbms_session.set_role in a logon trigger

2. Created a user with readonly access to the db. Issued a alter session set_current_schema to the new user

The first approach did not work because we cannot set role in a trigger. The second option did not work because it only changed the user's context. It did not change the privileges.

Any other ideas that I can try? Thanks!