|Subject||Re: DEFINE TRIGGER failed no permission for control access to TABLE|
> As SYSDBA or owner of TABLE1:This does not help. I forgot to mention that the non-admin SQL user has the ALL privilege(s) on TABLE1. This seems to include REFERENCES as well. I also tried to grant REFERENCES as you suggested but this did not solve the problem.
> GRANT REFERENCES ON TABLE1 TO <user>
> <user> is the user that needs to create the FK.