Re: insufficient privileges when creating a trigger

Double check the grants.

define WhichUser=USERNAME

select grantee, 'ROLE' privtype, granted_role privname, null owner, null table_name
from dba_role_privs
where grantee like upper('&WhichUser')
union
select grantee, 'TABPRIV' privtype, privilege privname, owner, table_name from dba_tab_privs
where grantee like upper('&WhichUser')
order by 1, 2, 3, 4;

On Mon, May 12, 2008 at 3:21 PM, <genegurevich_at_discover.com> 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
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l