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

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