Re: insufficient privileges when creating a trigger
- From: "Stefan Knecht" <knecht.stefan@xxxxxxxxx>
- To: genegurevich@xxxxxxxxxxxx
- Date: Tue, 13 May 2008 08:16:26 +0200
To create a trigger in another schema, you'll need CREATE ANY TRIGGER system
privilege.
Cheers
Stefan
On Tue, May 13, 2008 at 12:21 AM, <genegurevich@xxxxxxxxxxxx> wrote:
> Hello:
>
> 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
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
=========================
Stefan P Knecht
Senior Consultant
Infrastructure Managed Services
Trivadis AG
Europa-Strasse 5
CH-8152 Glattbrugg
Phone +41-44-808 70 20
Fax +41-808 70 12
Mobile +41-79-571 36 27
stefan.knecht@xxxxxxxxxxxx
http://www.trivadis.com
OCP 9i/10g SCSA SCNA
=========================
Other related posts:
