How can I create synonyms for tables in a database and give a user read only access to those tables. I don't want to use the schema name before querying the table as that read only user.
Well you can create a view for each table and grant access on the views. That way they can update/insert/delete data if they need to but they don't have direct access to the table.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply