Sets user account in state where user must specify a new password on next login. No other actions are allowed until the password is changed.

Syntax

RESTRICT 'username' IDENTIFIED BY 'password';

Arguments

  • userName: the name for the user. Optionally, enclose in single quotes.

  • password: specifies a temporary password for the user, which must be changed on next log in.

Additional Information

  • Can be used instead of DISABLE USER where you need to disable a user account immediately and force a password reset.

  • View User Account status in SYS.USERS

Examples

RESTRICT USER myUser1 IDENTIFIED BY 'p@ssw0rd';