Tuesday, October 26, 2010

Oracle Unlock Scott Account

Unlocking the Scott Account

So you forgot to unlock the Scott account, eh?
Using SQLPlusWorksheet, login as "system" using the password that you gave to system accounts when you installed oracle. Next, execute the following statements:

alter user scott account unlock;
grant connect, resource to scott;

That should do it. If you want to create new accounts, try this:

create user LOGINNAME profile default identified by PASSWORD;
alter user LOGINNAME account unlock;
grant connect, resource to PASSWORD;

No comments:

Post a Comment