SQL Server/T-SQL/System/sysusers
sysusers appears in the master database and in every user-defined database.
4> select top 10 * from sysusers;
5> GO
uid status name sid
roles
createdate upd
atedate altuid password
gid environ
hasdbaccess islogin isntname isntgroup isntuser issqluser isaliased issqlrole isapprole
------ ------ -------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------- ----------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------------------- ---
-------------------- ------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------------------------------------------- ------ --------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----- ----------- ----------- ----------- ----------- ----------- ----------- ----------- ----------- -----------
0 0 public 0x0105000000000009040000002E92BD1E36586647881631145F3643B
A
NULL
2003-04-08 09:10:19.630 200
5-10-14 01:36:15.737 1 NULL
0 NULL
0 0 0 0 0 0 0 1 0
1 0 dbo 0x01
NULL
2003-04-08 09:10:19.600 200
3-04-08 09:10:19.600 NULL NULL
0 NULL
1 1 0 0 0 1 0 0 0
2 0 guest 0x00
NULL
2003-04-08 09:10:19.647 200
3-04-08 09:10:19.647 NULL NULL
0 NULL
1 1 0 0 0 1 0 0 0
3 0 INFORMATION_SCHEMA NULL
NULL
2005-10-14 01:36:06.923 200
5-10-14 01:36:06.923 NULL NULL
0 NULL
0 1 0 0 0 1 0 0 0
4 0 sys NULL
NULL
2005-10-14 01:36:06.923 200
5-10-14 01:36:06.923 NULL NULL
0 NULL
0 1 0 0 0 1 0 0 0
5 0 ##MS_AgentSigningCertificate## 0x01060000000000090100000009FFDA09A06E24E170D86EEDDACD192
BAAEAE263
NULL
2005-10-14 01:56:18.613 200
5-10-14 01:56:18.613 NULL NULL
0 NULL
1 1 0 0 0 0 0 0 0
16384 0 db_owner 0x0105000000000009040000000000000000000000000000000040000
0
NULL
2003-04-08 09:10:19.677 200
5-10-14 01:36:15.737 1 NULL
16384 NULL
0 0 0 0 0 0 0 1 0
16385 0 db_accessadmin 0x0105000000000009040000000000000000000000000000000140000
0
NULL
2003-04-08 09:10:19.677 200
5-10-14 01:36:15.737 1 NULL
16385 NULL
0 0 0 0 0 0 0 1 0
16386 0 db_securityadmin 0x0105000000000009040000000000000000000000000000000240000
0
NULL
2003-04-08 09:10:19.693 200
5-10-14 01:36:15.737 1 NULL
16386 NULL
0 0 0 0 0 0 0 1 0
16387 0 db_ddladmin 0x0105000000000009040000000000000000000000000000000340000
0
NULL
2003-04-08 09:10:19.693 200
5-10-14 01:36:15.737 1 NULL
16387 NULL
0 0 0 0 0 0 0 1 0
(10 rows affected)
1>
2>