Home » Developer & Programmer » Forms » username access
username access [message #383058] Tue, 27 January 2009 02:34 Go to next message
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
Re: username access [message #383064 is a reply to message #383058] Tue, 27 January 2009 02:51 Go to previous messageGo to next message
Littlefoot
Messages: 20891
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;
Re: username access [message #383109 is a reply to message #383064] Tue, 27 January 2009 05:05 Go to previous message
jeyaprakashh
Messages: 7
Registered: January 2009
Location: oman
Junior Member
THANKS MR.LITTLEFOOT . NOW ITS WORKING FINE
Previous Topic: Updating all records with a single query
Next Topic: how to display arabic with forms 10g ?
Goto Forum:
  


Current Time: Sun Dec 04 04:37:53 CST 2016

Total time taken to generate the page: 0.04461 seconds