http://sqle.ru/index.php?action=history&feed=atom&title=SQL_Server%2FT-SQL_Tutorial%2FSystem_Functions%2Fsp_addrolemember 2026-07-15T19:23:56Z История изменений этой страницы в вики MediaWiki 1.30.0 http://sqle.ru/index.php?title=SQL_Server/T-SQL_Tutorial/System_Functions/sp_addrolemember&diff=6738&oldid=prev 2010-05-26T13:46:16Z

<p></p> <table class="diff diff-contentalign-left" data-mw="interface"> <tr style="vertical-align: top;" lang="ru"> <td colspan="1" style="background-color: white; color:black; text-align: center;">← Предыдущая</td> <td colspan="1" style="background-color: white; color:black; text-align: center;">Версия 13:46, 26 мая 2010</td> </tr><tr><td colspan="2" style="text-align: center;" lang="ru"><div class="mw-diff-empty">(нет различий)</div> </td></tr></table>

http://sqle.ru/index.php?title=SQL_Server/T-SQL_Tutorial/System_Functions/sp_addrolemember&diff=6739&oldid=prev 2010-05-26T10:24:02Z

<p>1 версия</p> <p><b>Новая страница</b></p><div>== Add role member==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> 2&gt;<br /> 3&gt; IF EXISTS(SELECT * FROM sys.tables<br /> 4&gt; WHERE name = &quot;TrackPersons&quot; AND schema_id = 1)<br /> 5&gt; DROP TABLE dbo.TrackPersons<br /> 6&gt; IF EXISTS(SELECT * FROM sys.tables<br /> 7&gt; WHERE name = &quot;TrackPersons&quot; AND schema_id = 5)<br /> 8&gt; DROP TABLE sqllogin3.TrackPersons<br /> 9&gt; GO<br /> 1&gt;<br /> 2&gt; EXEC sp_addrolemember &quot;db_ddladmin&quot;, &quot;sqllogin4&quot;<br /> 3&gt; GO<br /> 1&gt;<br /> 2&gt; EXECUTE AS login = &quot;sqllogin4&quot;&lt;/source&gt;<br /> <br /> <br /> <br /> == A statement that assigns a user to a database role==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> EXEC sp_AddRoleMember db_owner, JohnDoe&lt;/source&gt;<br /> <br /> <br /> <br /> == A statement that assigns the new role to a fixed database role==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> EXEC sp_AddRoleMember db_datareader, BillingEntry&lt;/source&gt;<br /> <br /> <br /> <br /> == How to assign a user to a database role==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> The syntax for sp_AddRoleMember<br /> sp_AddRoleMember [@rolename = ] &quot;database_role_name&quot;,<br /> [@membername = ] &quot;security_account&quot;&lt;/source&gt;<br /> <br /> <br /> <br /> == Statements that assign users to the new role==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> EXEC sp_AddRoleMember BillingEntry, JohnDoe<br /> EXEC sp_AddRoleMember BillingEntry, [Accounting\JaneSmith]&lt;/source&gt;</div>

Admin