📄 sql-7.html

📁 makefile 例子
💻 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> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</font><font
             face="奔覆" size="2" color="black"><b> sp_changeobjectowner &nbsp;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狼 家蜡磊啊 悼老秦具 
            &nbsp;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 &nbsp;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, &nbsp;db_securityadmin, &nbsp;sysadmin俊 加窍绰 User啊 
            积己<br>
            <br> &nbsp;&nbsp;&nbsp;&nbsp;sp_addapprole &nbsp;role疙, &nbsp;password 
            <br> &nbsp;&nbsp;&nbsp;&nbsp;sp_dropapprole<br> &nbsp;&nbsp;&nbsp;&nbsp;<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) &nbsp;&nbsp;GRANT select<br> On products<br> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;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%;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a
             href="sql-list.htm">府胶飘肺 倒酒啊扁</a></td>
    </tr>
</table></div>
</body>

</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -