Quote Originally Posted by chikkodi
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.