New global variable @@authmech  Access control

Chapter 7: Security Changes

System table changes

The status column from syslogins, a 16-bit integer datatype, has new bits assigned as follows:

Table 7-2: status column from syslogins table

Decimal

Hex

Status

1

0x1

Password contains fewer than six characters or is NULL.

2

0x2

Account is locked.

4

0x4

Password has expired.

8

0x8

User has RepSrv authorization.

16

0x10

OMNI:autoconnect mode is enabled.

32

0x20

Use Adaptive Server internal authentication mechanism – syslogins.

64

0x40

Use only LDAP external authentication.

128

0x80

Use only PAM external authentication.





Copyright © 2004. Sybase Inc. All rights reserved. Access control

View this book as PDF