📄 sql-6.html
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0//EN">
<html>
<head>
<title>User客 Role俊 permission林扁</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 ><p style="line-height:130%;"><font face="奔覆"
size="2" color="red"><b>User客 Role俊 permission林扁</b></font><font
face="奔覆" size="2" color="black"><br>
<br>
:秦寸 DB俊 user扼 秦档objects俊 Permission捞 绝栏搁, objects 荤侩捞
阂啊瓷窍促.<br>
<br>
</font><font face="奔覆" size="2" color="green"><b>1. 捞固 何咯等
鼻茄</b></font><font face="奔覆" size="2" color="black"><br>
<br>
-User吝 objects owner绰 弊 object俊 措秦辑 葛电 鼻茄阑 青荤且 荐
乐促.<br>
-Role吝 捞固 殿废等 Role(Fixed Server,Database Role)狼 版快, 捞固
鼻茄 肚茄 何咯 登绢 乐促.<br> <br>
</font><font face="奔覆" size="2" color="green"><b>2. New 鼻茄 何咯</b></font><font
face="奔覆" size="2" color="black"><br>
<br>
</font><font face="奔覆" size="2" color="blue"><b>辆幅</b></font><font
face="奔覆" size="2" color="black"><br>
<br>
</font><font face="奔覆" size="2" color="black"><b>1) 角青巩 鼻茄</b></font><font
face="奔覆" size="2" color="black"><br>
<br>
: 阿 DB User吝, 酒贰 巩厘阑 角青且 荐 乐绰 鼻茄捞 乐绰 User 父 ,
Objects甫 积己且 荐 乐促. <br>
<br>
Sysadmin, db_owner, db_securityadmin role狼 member父捞 角青巩 鼻茄阑
何咯且 荐 乐促.<br>
<br>
</font><font face="奔覆" size="2" color="violet"><b>角青巩 Object</b></font><font
face="奔覆" size="2" color="violet"><br>
Create Database,Table,
View, Procedure, Index, Rule, Default<br>
Backup DB, Log</font><font
face="奔覆" size="2" color="black"><br> <br>
</font><font face="奔覆" size="2" color="black"><b>2)Object 鼻茄</b></font><font
face="奔覆" size="2" color="black"><br>
<br>
:阿DB User甸篮 阿 Object付促 何咯 罐篮 鼻茄狼 裹困 郴俊辑 累诀 啊瓷<br>
<br>
</font><font face="奔覆" size="2" color="violet"><b>Object 鼻茄</b></font><font
face="奔覆" size="2" color="violet"><br>
Table, View Select
, insert, update, delete<br>
Column Select,
update, references<br>
Stored Procedure Exec</font><font face="奔覆" size="2"
color="black"><br> <br>
</font><font face="奔覆" size="2" color="blue"><b>鼻茄 何咯 规过</b></font><font
face="奔覆" size="2" color="black"><br>
<br>
</font><font face="奔覆" size="2" color="violet"><b>疙飞绢</b></font><font
face="奔覆" size="2" color="violet"><br>
GRANT 鼻茄 何咯<br>
DENY 鼻茄 老矫 荤侩 阂啊瓷<br>
REVOKE 鼻茄 何咯 枚雀</font><font face="奔覆" size="2" color="black"><br>
<br>
</font><font face="奔覆" size="2" color="black"><b>1.角青巩 鼻茄
何咯 规过</b></font><font face="奔覆" size="2" color="black"><br>
<br> Grant { all | 角青巩 鼻茄 [ , 角青巩 鼻茄 , ˇˇ] } <br>
To User疙, ˇ.<br>
<br> Deny { all | 角青巩 鼻茄 [, 角青巩 鼻茄,..]} <br> To
User疙,ˇ.<br>
<br> Revoke { all | 角青巩 鼻茄 [, 角青巩 鼻茄 ,..]} <br>
From User疙, ˇ.<br>
<br>
</font><font face="奔覆" size="2" color="black"><b>2.Object 鼻茄
何咯 规过</b></font><font face="奔覆" size="2" color="black"><br>
<br>
Grant {all[priviledges]|Object 鼻茄[,Object 鼻茄,..]}[(Column[ ,
..])]<br>
On {table|View|stored procedure| extended procedure}<br>
To User疙, ˇ.. [AS { group | role }]<br>
<br>
Deny{all[priviledges]|Object 鼻茄[,Object 鼻茄,..]}[(Column[ , ..])]<br>
On {table|View|stored procedure| extended procedure}<br>
To User疙, ˇ.. | AS { group | role }<br>
<br>
Revoke{all[priviledges]|Object 鼻茄 [,Object 鼻茄,..]} [(Column[
,..])] <br>
On {table|View|stored procedure| extended procedure}<br>
To User疙, ˇ.. [ AS { group | role }]<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 + -