Re: Unique Key Problem

Hero R. Post wrote:
>
> Hello everyone,
> We are experiencing a weird problem that even the guys at Oracle can't help
> us with.
> The problem is this:
> On one table, one user (the owner) can insert rows, but another user (with
> the correct rights to the table) get a unique constraint violation
> (ora-00001).
> >>The record referenced by index is absolutely not present,
> >>Both users access the table via a synonym
> >>and I am positive that the rights and roles are correct. Other tables do
> not seem to have this problem.
>
> Has any one seen this problem before.
> And can any one give us a hint on how to solve this.
> thanks
>
> Hero R. Post
>
> hero.post_at_orap.nl

Is there any possibility that you have *two* tables and that the second user is inserting into his/her own table instead of into the one owned by the first user?

-- 
Chrysalis

FABRICATI DIEM, PVNC
('To Protect and to Serve')
Terry Pratchett : "Guards, Guards"