Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Values stored in the Status field in Master..Syslogins
1,225 views
Skip to first unread message
michaelg
Sep 26, 2005, 9:37:06 AM9/26/05
to
What do the values in the status field of master..syslogins
represent?
I See values of 224, 226 & 0.
Only the sa login has a status of 0.
These are the only values that I see. Are there any other
possible values?
represent?
I See values of 224, 226 & 0.
Only the sa login has a status of 0.
These are the only values that I see. Are there any other
possible values?
Thanks
Mike
Bret Halford
Sep 26, 2005, 9:56:12 AM9/26/05
to
The status field is a bit-mapped field. A list of the different
documented bits
that can be set is in table 1-16, under the entry for "syslogins" in the
documented bits
that can be set is in table 1-16, under the entry for "syslogins" in the
Reference Manual.
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.docset.ase_docs_15.0/title.htm
There are many valid combinations of status bits, so many different
possible values.
224 = 0x80 + 0x40 + 0x20 = "use PAM" + "use LDAP" + "use internal
authentication"
226 = 0x80 + 0x40 + 0x20 + 0x02 = "use PAM" + "use LDAP" + "use internal
authentication" + "account locked"
an example of a value not currently seen on your server would be:
6 = 0x02 + 0x04 = "account locked" + "password expired"
-bret
0 new messages