Unlock an Oracle user with a batch file
Is there a way I can write a code into a batch file that will 开发者_运维知识库unlock a specific account in the specified database?
Call SQL*Plus (as a user with permissions to unlock accounts) from within the batch file and issue the DDL to unlock the user directly from in there.
Is that the sort of answer you were looking for or have I missed something in haste?
ALTER USER username ACCOUNT UNLOCK;
精彩评论