SQLSERVER 权限分配

---分配权限

GRANT SELECT , INSERT , UPDATE , DELETE ON open_invoice_info_result TO testinvoice

GRANT SELECT , INSERT , UPDATE , DELETE ON open_invoice_info_to_hangtian TO testinvoice

--创建登录

CREATE LOGIN Liang WITH PASSWORD='myfend@hotmail.com';

--创建用户

CREATE USER Liang FROM LOGIN Liang;

--授予用户对tb1有UPDATE某个列的权限，tb2只有SELECT权限

GRANT UPDATE(value) ON tb1 TO Liang

GRANT SELECT ON tb1 TO Liang

GRANT SELECT ON tb2 TO Liang

GO