Locking Out Users

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

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

   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