http://sqle.ru/index.php?action=history&feed=atom&title=SQL_Server%2FT-SQL_Tutorial%2FSystem_Tables_Views%2FSYSUSERS SQL Server/T-SQL Tutorial/System Tables Views/SYSUSERS - История изменений 2026-04-04T11:46:49Z История изменений этой страницы в вики MediaWiki 1.30.0 http://sqle.ru/index.php?title=SQL_Server/T-SQL_Tutorial/System_Tables_Views/SYSUSERS&diff=6931&oldid=prev в 13:46, 26 мая 2010 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_Tables_Views/SYSUSERS&diff=6932&oldid=prev Admin: 1 версия 2010-05-26T10:24:46Z <p>1 версия</p> <p><b>Новая страница</b></p><div>== Selecting a list of users and their groups.==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> 4&gt;<br /> 5&gt;<br /> 6&gt; SELECT user_name(s1.uid) AS UserName,<br /> 7&gt; user_name(s2.uid) as GroupName<br /> 8&gt; FROM sysusers s1<br /> 9&gt; JOIN sysusers s2 ON s1.gid = s2.uid<br /> 10&gt; WHERE s1.uid &lt;&gt; s1.gid<br /> 11&gt; UNION<br /> 12&gt; SELECT user_name(s1.uid) AS UserName,<br /> 13&gt; &quot;public&quot; as GroupName<br /> 14&gt; FROM sysusers s1<br /> 15&gt; JOIN sysusers s2 ON s1.gid = s2.uid<br /> 16&gt; WHERE s1.uid &lt;&gt; s1.gid<br /> 17&gt; AND s1.gid &lt;&gt; user_id(&quot;public&quot;)<br /> 18&gt; ORDER BY UserName, GroupName<br /> 19&gt; GO<br /> UserName GroupName<br /> -------------------------------------------------------------------------------------------------------------------------------- -----------------------------------------------------------------------<br /> ---------------------------------------------------------<br /> ##MS_AgentSigningCertificate## public<br /> dbo public<br /> guest public<br /> INFORMATION_SCHEMA public<br /> sys public<br /> <br /> (5 rows affected)&lt;/source&gt;<br /> <br /> <br /> <br /> == SYSUSERS table==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> 4&gt;<br /> 5&gt; SELECT * FROM SYSUSERS<br /> 6&gt;<br /> 7&gt; GO<br /> uid status name sid<br /> <br /> roles<br /> createdate upd<br /> atedate altuid password<br /> gid environ<br /> hasdbaccess islogin isntname isntgroup isntuser issqluser isaliased issqlrole isapprole<br /> ------ ------ -------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------<br /> --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br /> --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br /> --------------------------------------------------------- ----------------------------------------------------------------------------------------------------------------------------------------------<br /> --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br /> ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------------------- ---<br /> -------------------- ------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br /> --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br /> ---------------------------------------------------------------------------------------------------------------------------------------------- ------ --------------------------------------------------<br /> --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br /> ----- ----------- ----------- ----------- ----------- ----------- ----------- ----------- ----------- -----------<br /> 0 0 public 0x0105000000000009040000002E92BD1E36586647881631145F3643B<br /> A<br /> NULL<br /> 2003-04-08 09:10:19.630 200<br /> 5-10-14 01:36:15.737 1 NULL<br /> 0 NULL<br /> 0 0 0 0 0 0 0 1 0<br /> 1 0 dbo 0x01<br /> <br /> NULL<br /> 2003-04-08 09:10:19.600 200<br /> 3-04-08 09:10:19.600 NULL NULL<br /> 0 NULL<br /> 1 1 0 0 0 1 0 0 0<br /> 2 0 guest 0x00<br /> <br /> NULL<br /> 2003-04-08 09:10:19.647 200<br /> 3-04-08 09:10:19.647 NULL NULL<br /> 0 NULL<br /> 1 1 0 0 0 1 0 0 0<br /> 3 0 INFORMATION_SCHEMA NULL<br /> <br /> NULL<br /> 2005-10-14 01:36:06.923 200<br /> 5-10-14 01:36:06.923 NULL NULL<br /> 0 NULL<br /> 0 1 0 0 0 1 0 0 0<br /> 4 0 sys NULL<br /> <br /> NULL<br /> 2005-10-14 01:36:06.923 200<br /> 5-10-14 01:36:06.923 NULL NULL<br /> 0 NULL<br /> 0 1 0 0 0 1 0 0 0<br /> 5 0 ##MS_AgentSigningCertificate## 0x01060000000000090100000009FFDA09A06E24E170D86EEDDACD192<br /> BAAEAE263<br /> NULL<br /> 2005-10-14 01:56:18.613 200<br /> 5-10-14 01:56:18.613 NULL NULL<br /> 0 NULL<br /> 1 1 0 0 0 0 0 0 0<br /> 16384 0 db_owner 0x0105000000000009040000000000000000000000000000000040000<br /> 0<br /> NULL<br /> 2003-04-08 09:10:19.677 200<br /> 5-10-14 01:36:15.737 1 NULL<br /> 16384 NULL<br /> 0 0 0 0 0 0 0 1 0<br /> 16385 0 db_accessadmin 0x0105000000000009040000000000000000000000000000000140000<br /> 0<br /> NULL<br /> 2003-04-08 09:10:19.677 200<br /> 5-10-14 01:36:15.737 1 NULL<br /> 16385 NULL<br /> 0 0 0 0 0 0 0 1 0<br /> 16386 0 db_securityadmin 0x0105000000000009040000000000000000000000000000000240000<br /> 0<br /> NULL<br /> 2003-04-08 09:10:19.693 200<br /> 5-10-14 01:36:15.737 1 NULL<br /> 16386 NULL<br /> 0 0 0 0 0 0 0 1 0<br /> 16387 0 db_ddladmin 0x0105000000000009040000000000000000000000000000000340000<br /> 0<br /> NULL<br /> 2003-04-08 09:10:19.693 200<br /> 5-10-14 01:36:15.737 1 NULL<br /> 16387 NULL<br /> 0 0 0 0 0 0 0 1 0<br /> 16389 0 db_backupoperator 0x0105000000000009040000000000000000000000000000000540000<br /> 0<br /> NULL<br /> 2003-04-08 09:10:19.710 200<br /> 5-10-14 01:36:15.737 1 NULL<br /> 16389 NULL<br /> 0 0 0 0 0 0 0 1 0<br /> 16390 0 db_datareader 0x0105000000000009040000000000000000000000000000000640000<br /> 0<br /> NULL<br /> 2003-04-08 09:10:19.710 200<br /> 5-10-14 01:36:15.737 1 NULL<br /> 16390 NULL<br /> 0 0 0 0 0 0 0 1 0<br /> 16391 0 db_datawriter 0x0105000000000009040000000000000000000000000000000740000<br /> 0<br /> NULL<br /> 2003-04-08 09:10:19.710 200<br /> 5-10-14 01:36:15.737 1 NULL<br /> 16391 NULL<br /> 0 0 0 0 0 0 0 1 0<br /> 16392 0 db_denydatareader 0x0105000000000009040000000000000000000000000000000840000<br /> 0<br /> NULL<br /> 2003-04-08 09:10:19.723 200<br /> 5-10-14 01:36:15.737 1 NULL<br /> 16392 NULL<br /> 0 0 0 0 0 0 0 1 0<br /> 16393 0 db_denydatawriter 0x0105000000000009040000000000000000000000000000000940000<br /> 0<br /> NULL<br /> 2003-04-08 09:10:19.723 200<br /> 5-10-14 01:36:15.750 1 NULL<br /> 16393 NULL<br /> 0 0 0 0 0 0 0 1 0<br /> (15 rows affected)<br /> 1&gt;&lt;/source&gt;</div> Admin