Re: Error in running trigger

2009-12-22 Thread Ananda Kumar
please run this and lets us know the output show grants on root1; On Tue, Dec 22, 2009 at 5:50 PM, Krishna Chandra Prajapati < prajapat...@gmail.com> wrote: > Hi Ranjan, > > User doesn't have sufficient privileges. root access required. > > Thanks, > Krishna > > On Tue, Dec 22, 2009 at 3:26 PM,

Re: Error in running trigger

2009-12-22 Thread Krishna Chandra Prajapati
Hi Ranjan, User doesn't have sufficient privileges. root access required. Thanks, Krishna On Tue, Dec 22, 2009 at 3:26 PM, Jeetendra Ranjan < jeetendra.ran...@sampatti.com> wrote: > Hi, > > I have created the below trigger from root user with definer: > > CREATE definer=`*root...@`` TRIGGER `C

Re: Error in running trigger

2009-12-22 Thread Ananda Kumar
is it root or root1 user. Also is this trigger executed by root user or some other user. On Tue, Dec 22, 2009 at 3:26 PM, Jeetendra Ranjan < jeetendra.ran...@sampatti.com> wrote: > Hi, > > I have created the below trigger from root user with definer: > > CREATE definer=`roo...@`` TRIGGER `CONSUM