sp_expireallpasswords procedure

Function

Causes all user passwords to expire immediately.

Syntax1

call sp_expireallpasswords

Syntax2

sp_expireallpasswords

See also

“sp_iqpassword procedure”

CREATE USER Statement in Chapter 1, “SQL Statements,” in Reference: Statements and Options.

Permissions

DBA or USER ADMIN authority required.

Examples

Causes all user passwords to expire immediately:

call sp_expireallpasswords