Toad World® Forums

Add 'Lock & Expire' Option


could you please add the option "Lock & Expire" to the user menu:

We regularly need to lock and expire a user simultaneously. At the moment we have to use ALTER USER statements.

Friederich Reiß

You can do that by double-clicking the user to open the Alter User window, then just checking the lock and expire boxes, then OK. That's not bad for one user at a time.

If you do this often, and with multiple users, this technique may be helpful. I'm setting up a "Custom Query" for it. You'll only have to set it up once, then you can just right-click and choose "Lock and Expire"