Make SQL Select Query Read Only
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 s开发者_如何学JAVAtuff from the database!
create a new user with select only permissions. then use that user to connect.
ALTER DATABASE database-name SET READ_ONLY
http://www.blackwasp.co.uk/SQLReadOnly.aspx
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
精彩评论