I have a database instance which of course I can connect to and edit data. I would like to set up other users for this database that can just as easily connect but that only read data? What is easiest, quickest way? Thanks.
It is my idea:
1.) Modify database to readonly true.
2.) Create full backup from the database.
3.) Restore a new database from the backup.
4.) Modify data in the new database.
5.) Create full backup from the new database.
6.) Restor old database from the newest backup.
7.) Modify database to readonly false.