Checking for roles in stored procedures  Setting and changing the maximum login attempts

Chapter 14: Managing Adaptive Server Logins, Database Users, and Client Connections

Establishing a password and login policy

Adaptive Server includes several controls for setting policies for logins and passwords for internal authentication.

In Adaptive Server the System Security Officer can:

Negative values may be used for user IDs (uid).

The server user ID (suid) associated with a group or a role in sysusers is not equal to the negation of their user ID (uid). Every suid associated with a group or a role in sysusers is set to -2 (INVALID_SUID).





Copyright © 2005. Sybase Inc. All rights reserved. Setting and changing the maximum login attempts

View this book as PDF