Unlock an Oracle user with a batch file

Question

Is there a way I can write a code into a batch file that will unlock a specific account in the specified database?

score 1 · Answer 1 · answered Aug 12 '11 at 10:29

1

ALTER USER username ACCOUNT UNLOCK;

answered Aug 12 '11 at 10:29

schurik

score 1 · Accepted Answer · answered Aug 12 '11 at 10:32

1

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?

answered Aug 12 '11 at 10:32

Ollie

Thank you bud. I know it is ALTER USER username ACCOUNT UNLOCK; But I thought it might be different from the batch file but now I understand how stupid I was to think so – Mikayil Abdullayev Aug 12 '11 at 10:43

2 Answers2