I suspected that. I used to write applications using delphi, now I`m learning Forms and I`m facing some stupid problems. I wrote a simple procedure to insert data in a table in When-button-Pressed trigger ... the table belongs to user A, and the user B has the permission to insert data in this table. When I fill in the text items and press the button with user A it works, but when I press the button connected with the user B, oracle forms raises something like 'can`t check exclusivity in a fk constraint' .... I gave to user B all the priviledges related to the table the fk referes to, and nothing. Do you know what`s going on? I just want to insert data using when-button-pressed and not the insert symbol from default&smartbar.
Processing error encountered while checking a record's primary key items for uniqueness.
The table associated with the current block of the form does not exist, or you do not have authority to access the table.
1. Check priviliges for all tables in application for user A and B again.
2. (This is my suggest only) in foms applications use full objects names (schema.oblect). and u will have much less headace with grants and priviliges.
It's very strange. When I'm connected as USERA it works and when I connect as USERB it doesn't. I get the same error. I gave all the priviledges that Larry Ellinson could imagine to USERB and ... nothing.
Compare the privileges of USERA and USERB in user_tab_privs and user_sys_privs tables and see if something is missing for USERB. USERB needs SELECT ANY TABLE system privilege to select from another user's schema.
[Edited by kris109 on 02-19-2002 at 04:36 PM]
Remember the Golden Rule - He who has the gold makes the rules!
Ph.D., OCP 8i, 9i, 10g DBA