Ask the Expert

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 log in?

    Requires Free Membership to View

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

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.