Skip to Main Content

Oracle Database Discussions

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 all users in a database keeping some specific users open

user8983130Jan 26 2014 — edited Jan 29 2014

Hi,

I need to write a script which will  lock all the users except some mentioned users.  There is one problem most of my db users name is in integer. like 100, 101,102, u need to put " "  to search for it.

Can any one help me with this??

Regards,

This post has been answered by Alvaro on Jan 26 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 26 2014
Added on Jan 26 2014
6 comments
2,283 views