Make SQL Select Query Read Only

Question

Is there a way to set an "Select Only" Mode?

I work with SQL Server Management Studio and im afraid of editing some lines while selecting stuff from the database!

Answer 1

create a new user with select only permissions. then use that user to connect.

Answer 2

ALTER DATABASE database-name SET READ_ONLY

http://www.blackwasp.co.uk/SQLReadOnly.aspx

Answer 3

Yes, they are called user permissions. So you need to set the account you have only select rights to the database.

So

DENY insert ON all TO user
DENY update ON all TO user
DENY delete ON all TO user