Q

Unlocking a blocked admin user ID in an Oracle DB

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 login?

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?
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.
This was first published in May 2007

Dig Deeper

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchManufacturingERP

SearchOracle

SearchDataManagement

SearchAWS

SearchBusinessAnalytics

SearchCRM

SearchContentManagement

SearchFinancialApplications

Close