How to grant read-only access to the data in an application
Posted on 2015-01-21
I will soon be decommissioning an application but this application will still need to be accessible by the users for historic purposes. I want the users to be able to view data only and I am thinking about my options on making this possible since I don't see any permissions setting in the application that will help me out on this.
The application is AD integrated and it points to a SQL database. It seems that the application have created SQL logins for the application users.
I was wondering if it would be possible to set the users to read-only by just assigning datareader role to their SQL logins.
Have someone come across to a similar situation?
Any help will be greatly appreciated.