Database Administration (MOSC)

MOSC Banner

Cannot Operate on User

edited Oct 14, 2009 2:51AM in Database Administration (MOSC) 12 commentsAnswered
Sir,

We found a new user with strange name '***', triple star which was created when the database was created, it have number of tables. We want to alter that user ie; we want to reset the password for that user. When we are trying to operate on that an error is returned.

SQL> alter user "***" identified by star;

Error at line 1:

ORA-00604: error occured at recursive SQL level 1

ORA-00001: unique constraint (SYS.I_USER1) violated

Details of the user is

USERNAME        USER_ID          PASSWORDACCOUNT_STATUSLOCK_DATEEXPIRY_DATEDEFAULT_TABLESPACETEMPORARY_TABLESPACECREATEDPROFILEINITIAL_RSRC_CONSUMER_GROUP

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center