Hi,
Simple question time.

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.

Alex.

Hello,

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.

You can either add the user(s) to the db_datareader role in the database, or grant select permission on the schema.

Deleted my post.

Ok thanks. There's plenty on the web around user roles... e.g. Understanding roles in SQL Server security | TechRepublic

I am wondering if anyone knows what SQL query I can run to check user roles?

Thanks.

sp_helpuser

Thanks for everything.