34,587
社区成员
发帖
与我相关
我的任务
分享sql server2000下用户权限问题
有db1.user1和db2.user2，如何给user1赋予对user2下的表select，insert和update的权限？
...全文
请发表友善的回复…
发表回复
pengdali 2003-08-20
- 打赏
- 举报
--Create a login account for the 'test' user
execute sp_addlogin 'test','1234','Northwind',null
go
--Create a group
execute sp_addgroup 'testgroup'
go
--Add the test user to Database
execute sp_adduser 'test','test','testgroup'
go
grant update,insert
on customers -- YOU CAN DEFINED WHICH TABLE YOU WANT GRANT TO TEST USER
to testgroup
execute sp_addlogin 'test','1234','Northwind',null
go
--Create a group
execute sp_addgroup 'testgroup'
go
--Add the test user to Database
execute sp_adduser 'test','test','testgroup'
go
grant update,insert
on customers -- YOU CAN DEFINED WHICH TABLE YOU WANT GRANT TO TEST USER
to testgroup
flying120 2003-08-20
- 打赏
- 举报
对着db1.user1单击右键，选择属性，在数据库角色中允许 db_datareader,db_datawriter前打上钩就行了，user2同理
