--给user1 select 表table1的权限
GRANT SELECT
ON table1
TO user1--或者
--给user1,user2,user3 INSERT, UPDATE, DELETE 表authors的权限
GRANT INSERT, UPDATE, DELETE
ON table1
TO user1, user2, user3
GRANT SELECT
ON table1
TO user1--或者
--给user1,user2,user3 INSERT, UPDATE, DELETE 表authors的权限
GRANT INSERT, UPDATE, DELETE
ON table1
TO user1, user2, user3
http://blog.csdn.net/zlp321002/archive/2005/12/29/565064.aspx
exec sp_addlogin 'XunJian2005','XunJian2005','XunJianSys' --添加到数据库
exec sp_grantdbaccess 'XunJian2005'--授权
GRANT ALL TO XunJian2005
GO
if not exists (select * from dbo.sysusers where name = N'XunJian2005' and uid < 16382)
EXEC sp_grantdbaccess N'XunJian2005', N'XunJian2005'
go