Q
Problem solve Get help with specific problems with your technologies, process and projects.

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.

Dig Deeper on SAP security

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.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchERP

SearchOracle

SearchDataManagement

SearchAWS

SearchBusinessAnalytics

SearchContentManagement

SearchHRSoftware

Close