Locking Out Users

You can force a user to be locked out by having a login policy specifically for locked-out users.

Create a login policy with login policy option locked=ON, as follows:

  1. CREATE LOGIN POLICY locked_users locked=ON
  2. Assign a user whom you want to lock out to the locked_users policy, for example:
    ALTER USER john LOGIN POLICY locked_users