/** 分配權限 **/

use [master]
create login [ln-tf\liaobin] from windows;
go
grant control server to [ln-tf\liaobin]; --授予管理員完全控制權限
go

create login [ln-tf\shipping staff] from windows
?with default_database=[db_packs];
go

use [db_packs];
go
create user ln_shp for login [ln-tf\shipping staff];
go
-- 授予包裝部表操作權限
grant select,delete,update,insert on database::db_packs to [ln_shp];
go

?

use [master];
go
create database [demo1];
go
use [demo1];
go
create schema sch_demo1;
go
create table table1(tid int);
create table table2(tid int);
go
create table sch_demo1.table3(tid int);
go
create login [ln-tf\liaobin] from windows
?with default_database=demo1;
go

?

/** SQL 2000 分配權限 **/
use [db_packs];
go
sp_adduser @loginame = 'ln-tf\liaobin'
go

use [master]
EXEC sp_grantlogin [ln-tf\liaobin];
go
grant all to [ln-tf\liaobin] with grant option; --授予管理員完全控制權限
go
EXEC sp_grantlogin [ln-tf\shipping staff];
go

-- 授予包裝部表操作權限
grant select,delete,update,insert on db_packs to [ln-tf\shipping staff];
go

轉載于:https://www.cnblogs.com/lbnnbs/p/4781554.html

總結

以上是生活随笔為你收集整理的MS SQL 2000 分配权限的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。