| Strange User *** [message #426852] |
Tue, 20 October 2009 01:55  |
saleh_binmasood
Messages: 30
Registered: October 2009
|
Member |
|
|
Sir,
In our database there is a user seen with name ***. It have same privilages as the user SYS have. The objects of ***are the same as the SYS user. Even the user_id for both users are same.
The SYS user is having user_id= 0 and the user *** has the user_id= 0.
In other words user *** is the clone of SYS user.
When i am trying to operate on this user. Its giving the error
For Example:
alter user *** identified by it;
ERROR at line 1
ORA-00604 error occoured at recursive SQL level1
ORA-00001 unique constraint (SYS.I_USER1) violated
Please HELPPPPPP
Thanks
|
|
|
|
| Re: Strange User *** [message #426865 is a reply to message #426852] |
Tue, 20 October 2009 02:38  |
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
When you say 'Cloned', does it have the same Created Date in Dba_Users?
You should be able to operate on this user by wrapping the username in ""
iealter user "***" identified by it;
I'd say that either you'e got a major security problem, or a very odd bug.
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Strange User *** [message #426894 is a reply to message #426892] |
Tue, 20 October 2009 04:44 |
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
Lots of people round here don't/won't read attachments.
USER# NAME TYPE# PASSWORD DATATS# TEMPTS# CTIME PTIME EXPTIME LTIME RESOURCE$ AUDIT$ DEFROLE DEFGRP# DEFGRP_SEQ# ASTATUS LCOUNT DEFSCHCLASS EXT_USERNAME SPARE1 SPARE2 SPARE3 SPARE4 SPARE5 SPARE6
0 SYS 1 C25321863066B3B5 0 3 2005-08-30 13:50:29.0 2007-09-15 11:54:36.0 0 1 0 0 DEFAULT_CONSUMER_GROUP 0
0 *** 1 ***TRIAL MODE*** 0 3 2005-08-30 13:50:29.0 2007-09-15 11:54:36.0 0 1 0 0 ***TRIAL MODE*** 0
|
|
|
|
|
|
|
|
| Re: Strange User *** [message #426907 is a reply to message #426897] |
Tue, 20 October 2009 05:32 |
saleh_binmasood
Messages: 30
Registered: October 2009
|
Member |
|
|
Sir,
BANNER
---------------------------
-------------------------------------
Oracle Database 10g Enterprise Edition Release
10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE
10.2.0.1.0 Production
TNS for 32-bit Windows: Version
10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
----------------------------------------------------------------
Total: 5
We didnot found any errors in alert logfile on that date
|
|
|
|
| Re: Strange User *** [message #426916 is a reply to message #426896] |
Tue, 20 October 2009 05:51 |
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
Nothing leaps to mind from the information posted.
Unless it's something odd that came with your version of Oracle, I'd raise an SR with Oracle and ask them about it.
|
|
|
|
| Re: Strange User *** [message #426919 is a reply to message #426916] |
Tue, 20 October 2009 05:57 |
saleh_binmasood
Messages: 30
Registered: October 2009
|
Member |
|
|
Even We are struck here. We could not find any thing in alertlog file. We cannot even do any thing to the ghost user ***.
Could the dropping of the user is possible?
Will the dropping effects the data?
Thanks everybody
|
|
|
|
|
|
|
|
| Re: Strange User *** [message #426927 is a reply to message #426923] |
Tue, 20 October 2009 06:20 |
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
Given that you're getting errors trying to alter this user, I'd talk to Oracle at this point.
I would be very, very wary of trying to drop the user.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
