Opened 12 years ago
Closed 12 years ago
#796 closed defect (fixed)
New user gave Oracle error
| Reported by: | osjonathan | Owned by: | |
|---|---|---|---|
| Priority: | major | Milestone: | v2.6.5 |
| Component: | General | Version: | v2.6.4 |
| Keywords: | Cc: |
Description
Hi, I tried adding a new user and got this error:
SQLException : ORA-00001: unique constraint (GEONETWORK.SYS_C0011916) violated
Using an Oracle database. The user appears to have been added, though some googling suggestions that maybe the user already existed, but I don't remember adding them before so.... :-S
Change History (2)
comment:1 by , 12 years ago
comment:2 by , 12 years ago
| Resolution: | → fixed |
|---|---|
| Status: | new → closed |
Added a check to make sure that a new user can't be registered with an existing username - svn revision 8747 - thanks
Note:
See TracTickets
for help on using tickets.
If I try and delete the user I get this error:
SQLException : ORA-02292: integrity constraint (GEONETWORK.SYS_C0011968) violated - child record found
Editing the user and changing the user password work fine.
After further investigation, the user did already exist. The bug therefore is that geonetwork should handle re-registration of the same user much better than it currently does.