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

Creating a password expiration interval for a new login

Use sp_addlogin to set the password expiration interval for a new login.

This example creates the new login joe with the password “Djdiek3”, and sets the password expiration interval for joe to 2 days:

sp_addlogin joe, "Djdiek3", null, null, null, 2

For details on the syntax and rules for using the new parameter, see sp_addlogin in the Reference Manual: System Procedures.