Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Lock and expire all users

ssmmssMar 24 2014 — edited Mar 24 2014

except sys, system and sysman.

Doing this manually would take forever. It looks like afcpexpire.sql would only expire users but not lock them and even with that I didn't know how to run the script.

I'm new at this and still trying to figure out how to do it. Some senior folks are saying this can be done, and some others are saying it has to be done manually.

Kindly advise.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 21 2014
Added on Mar 24 2014
2 comments
1,670 views