question

Theo Spears avatar image
Theo Spears asked

How do I unlock an account?

When attempting to log in with a particular account I get the error message:

ORA-28000: The Account is locked.

How do I go about unlocking the account?

useraccountlocked
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

2 Answers

·
prodlife avatar image
prodlife answered

alter user account unlock;

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

HillbillyToad avatar image
HillbillyToad answered

Some accounts are meant to be locked. You'll have schemas that exist for the purpose of containing data, but are not meant for active development. Make sure your DBA approves your change, otherwise you could open a big security hole in your database, esp if you are working with an account with a default password like SCOTT/TIGER

1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

thecoop avatar image thecoop commented ·
+1 nice answer with the security aspect as well...
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.