Unlocking a blocked admin user ID in an Oracle DB
Posted by
Admin at
|
Share this post:
|
|
0 Comments
My admin user ID has been locked out. Is there a table I can update in Oracle to reset the flag and enable myself to log in?
EXPERT RESPONSE
Select all entries of table USR02 where ‘UFLAG’=128. These users are locked by reason of incorrect logons. ‘UFLAG’=64 will give you the users that are blocked by Administrator. Set ‘UFLAG’ to 0, to unlock your account.
Keyword: BASIS
Title : Unlocking a blocked admin user ID in an Oracle DB
