Assigning a Login Policy to an Existing User

Use Interactive SQL to assign a login policy to an existing user.

Prerequisites
Requires the MANAGE ANY LOGIN POLICY system privilege.
Task
  1. To change the login policy assigned to a user, execute:
    ALTER USER userID
LOGIN POLICY  policy_name
  2. Have the user log out and back in to apply the new login policy.
Parent topic: Login Policies
Related reference
ALTER USER Statement