Re: insufficient privileges when creating a trigger
Date: Tue, 13 May 2008 08:10:25 +0200
I think that to be able to create a trigger on some other schema's table, you require the CREATE ANY TRIGGER system privilege.
On 5/13/08, genegurevich_at_discover.com <genegurevich_at_discover.com> wrote:
> I am getting the following error when trying to create a trigger:
> CREATE OR REPLACE TRIGGER ALT_ID_ASSIGN BEFORE INSERT ON USM_USER
> ERROR at line 1:
> ORA-01031: insufficient privileges
> I have granted select and DML privileges on the USM_USER table to the ID I
> am logged in as,
> I have granted create trigger to this ID as well and created a synonyms
> USM_USER pointing to
> the table. When I login as the User who actually owns the USM_USER table,
> trigger is being
> created without issues. I have opened an SR with Oracle 5 days ago with no
> progress so far.
> I am running oracle 9208. Is there anything else that I should look at
> which could explain this error?
> thank you
> Gene Gurevich
-- +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+- Toon Koppelaars RuleGen BV +31-615907269 toon_at_rulegen_dot_com www_dot_rulegen_dot_com Author: "Applied Mathematics for Database Professionals" -- http://www.freelists.org/webpage/oracle-lReceived on Tue May 13 2008 - 01:10:25 CDT