Re: HELP!! can not create trigger

ora_at_www.co.mo.md.us wrote:
>
> we have Oracle 7.3.2 installed on SUN SOlaris 2.5. A user reported he can not
> create trigger through SQL-Windows. The error message is " 1031 - insufficient
> previliege". The user can create table without problem. Can anyone tell me
> what wrong it is? Thank you for help.

does the user have the CREATE TRIGGER privilege ?

enter SQLDBA ,and after connecting internal, type :

GRANT CREATE TRIGGER TO username;

ASAF SHOVAL
ORACLE DBA,ISRAEL Received on Fri Jul 05 1996 - 00:00:00 CEST