📄 sql-5.html
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0//EN">
<html>
<head>
<title>Database User客 Database Role殿废窍扁</title>
<meta name="generator" content="Namo WebEditor v3.0">
</head>
<body bgcolor="white" text="black" link="blue" vlink="purple" alink="red">
<div align="center"><table border="0" width="80%">
<tr>
<td valign="top"><p><font face="奔覆" size="2" color="red"><b>Database
User客 Database Role殿废窍扁</b></font><font face="奔覆" size="2"
color="black"><br> <br> : SQL Server荤侩磊绰 Login拌沥捞 乐绢档
立辟窍妨绰 Database狼 User肺 殿废登芭唱 Role俊 加秦具 , 秦寸 DB狼
立辟捞 啊瓷窍促 <br> <br> </font><font face="奔覆" size="2" color="red"><b>Login拌沥阑
User肺 殿废</b></font><font face="奔覆" size="2" color="black">
<br> <br> </font><font face="奔覆"
size="2" color="green"><b>1.User 殿废窍扁</b></font><font face="奔覆"
size="2" color="black"> <br> <br> Query Analyzer俊辑<br> <br> </font><font
face="奔覆" size="2" color="black"><b>sp_grantdbaccess ‘login’,[‘User疙’]<br>
sp_revokedbaccess<br>
sp_change_users_login</b></font><font
face="奔覆" size="2" color="black"><br> <br> <br> </font><font face="奔覆"
size="2" color="green"><b>2.捞固 殿废等 User疙</b></font><font
face="奔覆" size="2" color="black"> <br> <br> </font><font face="奔覆"
size="2" color="black"><b>DBO</b></font><font face="奔覆" size="2"
color="black">: sa, system Administrators(sysadmin)
role啊 捞 user肺 mapping等促.<br> 搬内
力芭 阂啊瓷茄 user疙<br> </font><font face="奔覆" size="2" color="black"><b>Guest</b></font><font
face="奔覆" size="2" color="black">: DB俊 user肺 殿废登瘤 臼篮
荤侩磊绰 酒贰 炼扒 父练矫 guest肺 立辟 啊瓷<br> <br> </font><font
face="奔覆" size="2" color="red"><b>User甫 Database Role俊 眠啊窍扁</b></font><font
face="奔覆" size="2" color="blue"><b>-7.0 New</b></font><font face="奔覆"
size="2" color="black"> <br> <br> :Database Role俊 何咯等 鼻茄篮,
弊 Role俊 加茄 葛电 user甸俊霸 何咯等促.<br> <br> </font><font face="奔覆"
size="2" color="green"><b>1. 捞固 殿废等Database Roles</b></font><font
face="奔覆" size="2" color="black"> <br> <br> </font><font face="奔覆"
size="2" color="blue">1)辆幅</font><font face="奔覆" size="2" color="black"><br>
<br> </font><font face="奔覆" size="2" color="black"><b>Role Permission</b></font><font
face="奔覆" size="2" color="black"><br> public 阿DB俊
殿废等 葛电 User甸捞 馆靛矫 加窍霸 登绰 group.<br> Default肺
阿 DB狼 User甸篮 葛滴 秦寸 db狼 public group俊 何咯等 鼻茄阑 啊瘤霸
等促. <br> db_owner DB俊辑
owner 鼻茄阑 啊瘤绰 group. <br> 秦寸
DB俊辑 葛电 role狼 鼻茄 啊咙.<br> db_accessadmin 阿
DB狼 users, groups, role阑 眠啊, 昏力 <br> db_ddladmin
阿
DB狼 objects甫 眠啊, 函版, 昏力 <br> db_security admin 阿
DB俊辑 疙飞巩 荐青鼻茄捞唱 objects俊 鼻茄阑 何咯 <br> db_backupoperator
阿 DB俊辑 归诀苞 汗备 荐青<br> db_datareader
阿
DB狼 葛电 table狼 Data 八祸 啊瓷<br> db_datawriter 阿
DB狼 葛电 table狼 Data 眠啊, 函版, 昏力 啊瓷<br> db_denydatareader
阿 DB狼 葛电 Table狼 Data 佬扁 阂啊瓷<br>
db_denydatawriter 阿 DB狼 葛电 Table狼
Data 搁版 阂啊瓷<br> <br> <br> </font><font face="奔覆" size="2"
color="blue">2) Role俊 眠啊窍扁</font><font face="奔覆" size="2"
color="black"><br> : db_owner, Role owner , 眠啊窍妨绰 fixed
Databse role狼 member<br> <br> </font><font face="奔覆"
size="2" color="black"><b> sp_addrolemember
role,’DB User疙’<br> sp_droprolemember</b></font><font
face="奔覆" size="2" color="black"><br> <br> </font><font face="奔覆"
size="2" color="green"><b>2. New Database Roles</b></font><font
face="奔覆" size="2" color="black"><br> :秦寸 DB俊辑 悼老茄 鼻茄阑
青荤窍绰 user甸阑 困秦 Role阑 父甸荐 乐促.<br> <br> </font><font
face="奔覆" size="2" color="blue">1)Role积己</font><font face="奔覆"
size="2" color="black"><br> db_owner, db_securityadmin捞 role积己
啊瓷窍促.<br> <br> </font><font face="奔覆" size="2"
color="black"><b> sp_addrole role,
owner<br> sp_droprole
</b></font><font face="奔覆" size="2" color="black"><br> <br> </font><font
face="奔覆" size="2" color="blue">2) Role俊 眠啊窍扁</font><font
face="奔覆" size="2" color="black"><br> : db_owner, Role
owner捞 Role俊 眠啊 啊瓷窍促.<br> <br> <br> </font><font
face="奔覆" size="2" color="black"><b> sp_addrolemember
role,’DB User疙’<br> sp_droprolemember
</b></font><font face="奔覆" size="2" color="black"><br> <br>
<br> </font></p>
<p style="line-height:130%;"> <a
href="sql-list.htm">府胶飘肺 倒酒啊扁</a></td>
</tr>
</table></div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -