OraFAQ Forum: Forms » username access

Home » Developer & Programmer » Forms » username access

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

username access [message #383058]

Tue, 27 January 2009 02:34

jeyaprakashh
Messages: 7
Registered: January 2009
Location: oman

Junior Member

i install oracle10gr2 in my machine.i want to logon scott/tiger but it wont allowed them. it shows username is locked. whati have to do... i want to access emp and dept tables..
please give me solution for me

Report message to a moderator

Re: username access [message #383064 is a reply to message #383058]

Tue, 27 January 2009 02:51

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Unlock the account; connect to the database as a privileged user (such as SYS) (SQL*Plus connection) and alter user:

ALTER USER scott ACCOUNT UNLOCK;

Report message to a moderator

Re: username access [message #383109 is a reply to message #383064]

Tue, 27 January 2009 05:05

jeyaprakashh
Messages: 7
Registered: January 2009
Location: oman

Junior Member

THANKS MR.LITTLEFOOT . NOW ITS WORKING FINE

Report message to a moderator

Previous Topic:	Updating all records with a single query
Next Topic:	how to display arabic with forms 10g ?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 03 17:50:25 CST 2025