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:
CREATE LOGIN POLICY locked_users locked=ON
Assign a user whom you want to lock out to the locked_users policy, for example:
ALTER USER john LOGIN POLICY locked_users
