Limit db access to users using Access or Toad

[dbasan]

Thanks for the quick response, but to clarify my question, I just want the data to be readonly for Access and Toad users. Users logging in through the application should be able to operate normally.

Create a Role granted with SELECT any tables,..........and grant this role to the users you need.