开发者

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
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜