Showing results for 
Search instead for 
Did you mean: 

Unlock user id via sql(oracle) command

Former Member
0 Kudos

Hi experts,

I update the uflag in usr02 table oracle command to unlock the user in ecc 6.0

Update sapsr3.usr02 set uflag=0 where mandt=200 and bname='vivek'


but login not possible.

if there is any method to unlock user via OS  and database level.

Ecc 6.0

Oracle 10g on RHEL 5.3



View Entire Topic
Former Member

Hi Vivek

After giving the sql command, give commit.

Otherwise it doesn't save until you log out of sql command prompt, and at times, not even then.

0 Kudos
I wish I had seen this advice earlier.Loggin out of sql promt is what I was missing.