| Subject | Re: DEFINE TRIGGER failed no permission for control access to TABLE |
|---|---|
| Author | partsi |
| Post date | 2010-04-06T08:09:40Z |
> 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.
>