📄 sql-7.html
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0//EN">
<html>
<head>
<title>User疙 DBO肺 object甫 父甸磊</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 bgcolor="#F0F0F0"><p style="line-height:130%;"><font face="奔覆"
size="2" color="red"><b>User疙 DBO肺 object甫 父甸磊</b></font><font
face="奔覆" size="2" color="black"><br>
<br>
: Object狼 家蜡磊肺 DBO肺 老包且 巴阑 眠玫茄促.<br>
Sysadmin俊 加窍绰 Login拌沥篮 User疙 DBO 肺 mapping等促.<br>
<br>
家蜡磊啊 老包等 版快, object甫 曼炼且 锭, 家蜡磊疙阑 疙矫窍瘤 臼酒档
等促.<br> <br>
</font><font face="奔覆" size="2" color="black"><b>[Object家蜡磊
函版 过]</b></font><font face="奔覆" size="2" color="black"><br>
: db_owner, db_ddladmin, securityadmin捞 家蜡磊 函版 啊瓷<br> </font><font
face="奔覆" size="2" color="black"><b> sp_changeobjectowner object,
owner</b></font><font face="奔覆" size="2" color="black"><br>
<br>
<br>
</font><font face="奔覆" size="2" color="red"><b>View, Stored Procedure狼
鼻茄</b></font><font face="奔覆" size="2" color="black"><br>
<br>
</font><font face="奔覆" size="2" color="black"><b>1) View</b></font><font
face="奔覆" size="2" color="black"><br>
: View俊 措茄 select 鼻茄 乐栏搁 View客 扁馆 table狼 家蜡磊啊 悼老秦具
View select啊瓷, 父距 促福促搁 葛滴俊 Select鼻茄乐绢具 茄促.<br>
<br>
</font><font face="奔覆" size="2" color="black"><b>2) Stored Procedure</b></font><font
face="奔覆" size="2" color="black"><br>
:stored procedure 狼 角青 鼻茄( Execute)父 乐栏搁 角青 啊瓷窍促.<br>
<br>
<br>
</font><font face="奔覆" size="2" color="red"><b>Application Role阑
荤侩窍咯 Client Application促风扁</b></font><font face="奔覆"
size="2" color="black"><br>
: 漂沥茄 Application 力累 矫 SQL Server狼 漂沥 DB客狼 焊救 汲沥阑
固府 秦寸 DB俊 父甸绢 敌 Application Role肺 沥窍搁, 弊 Application阑
荤侩窍绰 葛电 荤侩磊绰 弊 Role 狼 鼻茄阑 青荤 啊瓷窍促<br>
<br>
</font><font face="奔覆" size="2" color="black"><b>1.Application
Role积己</b></font><font face="奔覆" size="2" color="black"><br>
: db_owner, db_securityadmin, sysadmin俊 加窍绰 User啊
积己<br>
<br> sp_addapprole role疙, password
<br> sp_dropapprole<br> <br>
cf) sp_spprolepassword :password 函版<br>
<br>
<br>
</font><font face="奔覆" size="2" color="black"><b>2.Application
Role俊 鼻茄 何咯</b></font><font face="奔覆" size="2" color="black"><br>
<br>
Ex) GRANT select<br> On products<br> To
role疙<br> <br>
<br>
</font><font face="奔覆" size="2" color="black"><b>3.Application
Role 利侩</b></font><font face="奔覆" size="2" color="black"><br>
<br>
:User 啊 SQL Server俊辑 楷版阑 谗阑 锭鳖瘤 弊 DB郴俊辑 Application
Role利侩篮 蜡瓤窍促.<br>
流立利牢 sp_setapprole巩阑 利侩秦具 茄促. 溜 促弗 stored procedure唱
transaction俊辑 角青 阂啊瓷窍促.<br>
<br>
Sp_setapprole {‘role疙’, ‘password’}<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 + -