且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何限制用户更新SQL Server 2005中的表

更新时间:2023-02-07 09:58:47

Set the permissions on that table for the user, using the UI for SQL Server or GRANT/REVOKE statements (see here[^]).


You need to give just SELECT permission. Revoke all permissions of the user and GRANT SELECT :
USE AdventureWorks2012;
REVOKE ALL ON Person.Address TO RosaQdM;
GRANT SELECT ON Person.Address TO RosaQdM;
GO