Error in running trigger

------=_NextPart_000_0035_01CA831B.2B296810
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi,

I have created the below trigger from root user with definer:

CREATE DEFINER=3D`root1`@`` TRIGGER `CONSUMER_PROFILE_before_delete` =
BEFORE DELETE ON CONSUMER_PROFILE FOR EACH ROW
begin=20
INSERT INTO =
DELETED_CONSUMER_PROFILE(CONSUMER_ID,CONSUMER_TYPE_ID,ENTERP RISE_URL_ID,C=
ONSUMER_FIRST_NAME,CONSUMER_MIDDLE_INITIAL,CONSUMER_LAST_NAM E,
DATE_OF_BIRTH,GENDER,MARITAL_STATUS,MARRIED_TO,LOCALE_ID,PRO FILE_PHOTO_PA=
TH,STATUS,SKIP_STEP,LAST_MOD_TIME,LAST_MOD_BY )=20

VALUES(old.CONSUMER_ID,old.CONSUMER_TYPE_ID,old.ENTERPRISE_U RL_ID,old.CON=
SUMER_FIRST_NAME,old.CONSUMER_MIDDLE_INITIAL,
old.CONSUMER_LAST_NAME,old.DATE_OF_BIRTH,old.GENDER,old.MARI TAL_STATUS,ol=
d.MARRIED_TO,old.LOCALE_ID,old.PROFILE_PHOTO_PATH,
old.STATUS,old.SKIP_STEP,old.LAST_MOD_TIME,old.LAST_MOD_BY ); end;

But when i see the trigger using show trigger command on mysql front it =
doesn't show and when i run the stament to hit the trigger it gives the =
error "SQL execution erro # 1227. Response from the database: Access =
denied ; you need the SUPER privilege for this operation".=20

But this user has all privilege. Why it is not executing ?

Thanks in advance.

Regards
Jeetendra Ranjan
------=_NextPart_000_0035_01CA831B.2B296810--

Re: Error in running trigger

--00504502bda639764a047b4ebebd
Content-Type: text/plain; charset=ISO-8859-1

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.ranjan@sampatti.com> wrote:

> Hi,
>
> I have created the below trigger from root user with definer:
>
> CREATE DEFINER=`root1`@`` TRIGGER `CONSUMER_PROFILE_before_delete` BEFORE
> DELETE ON CONSUMER_PROFILE FOR EACH ROW
> begin
> INSERT INTO
> DELETED_CONSUMER_PROFILE(CONSUMER_ID,CONSUMER_TYPE_ID,ENTERP RISE_URL_ID,CONSUMER_FIRST_NAME,CONSUMER_MIDDLE_INITIAL,CONS UMER_LAST_NAME,
> DATE_OF_BIRTH,GENDER,MARITAL_STATUS,MARRIED_TO,LOCALE_ID,PRO FILE_PHOTO_PATH,STATUS,SKIP_STEP,LAST_MOD_TIME,LAST_MOD_BY
> )
>
>
> VALUES(old.CONSUMER_ID,old.CONSUMER_TYPE_ID,old.ENTERPRISE_U RL_ID,old.CONSUMER_FIRST_NAME,old.CONSUMER_MIDDLE_INITIAL,
>
> old.CONSUMER_LAST_NAME,old.DATE_OF_BIRTH,old.GENDER,old.MARI TAL_STATUS,old.MARRIED_TO,old.LOCALE_ID,old.PROFILE_PHOTO_PA TH,
> old.STATUS,old.SKIP_STEP,old.LAST_MOD_TIME,old.LAST_MOD_BY ); end;
>
> But when i see the trigger using show trigger command on mysql front it
> doesn't show and when i run the stament to hit the trigger it gives the
> error "SQL execution erro # 1227. Response from the database: Access denied
> ; you need the SUPER privilege for this operation".
>
> But this user has all privilege. Why it is not executing ?
>
> Thanks in advance.
>
> Regards
> Jeetendra Ranjan

--00504502bda639764a047b4ebebd--

Re: Error in running trigger

--0015177404c6444a15047b503aed
Content-Type: text/plain; charset=ISO-8859-1

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.ranjan@sampatti.com> wrote:

> Hi,
>
> I have created the below trigger from root user with definer:
>
> CREATE DEFINER=`*root1*`@`` TRIGGER `CONSUMER_PROFILE_before_delete`
> BEFORE DELETE ON CONSUMER_PROFILE FOR EACH ROW
> begin
> INSERT INTO
> DELETED_CONSUMER_PROFILE(CONSUMER_ID,CONSUMER_TYPE_ID,ENTERP RISE_URL_ID,CONSUMER_FIRST_NAME,CONSUMER_MIDDLE_INITIAL,CONS UMER_LAST_NAME,
> DATE_OF_BIRTH,GENDER,MARITAL_STATUS,MARRIED_TO,LOCALE_ID,PRO FILE_PHOTO_PATH,STATUS,SKIP_STEP,LAST_MOD_TIME,LAST_MOD_BY
> )
>
>
> VALUES(old.CONSUMER_ID,old.CONSUMER_TYPE_ID,old.ENTERPRISE_U RL_ID,old.CONSUMER_FIRST_NAME,old.CONSUMER_MIDDLE_INITIAL,
>
> old.CONSUMER_LAST_NAME,old.DATE_OF_BIRTH,old.GENDER,old.MARI TAL_STATUS,old.MARRIED_TO,old.LOCALE_ID,old.PROFILE_PHOTO_PA TH,
> old.STATUS,old.SKIP_STEP,old.LAST_MOD_TIME,old.LAST_MOD_BY ); end;
>
> But when i see the trigger using show trigger command on mysql front it
> doesn't show and when i run the stament to hit the trigger it gives the
> error "SQL execution erro # 1227. Response from the database: Access denied
> ; you need the SUPER privilege for this operation".
>
> But this user has all privilege. Why it is not executing ?
>
> Thanks in advance.
>
> Regards
> Jeetendra Ranjan

--0015177404c6444a15047b503aed--

Re: Error in running trigger

--0016368e22af89bc9a047b508adb
Content-Type: text/plain; charset=ISO-8859-1

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 <
prajapatikc@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, Jeetendra Ranjan <
> jeetendra.ranjan@sampatti.com> wrote:
>
> > Hi,
> >
> > I have created the below trigger from root user with definer:
> >
> > CREATE DEFINER=`*root1*`@`` TRIGGER `CONSUMER_PROFILE_before_delete`
> > BEFORE DELETE ON CONSUMER_PROFILE FOR EACH ROW
> > begin
> > INSERT INTO
> >
> DELETED_CONSUMER_PROFILE(CONSUMER_ID,CONSUMER_TYPE_ID,ENTERP RISE_URL_ID,CONSUMER_FIRST_NAME,CONSUMER_MIDDLE_INITIAL,CONS UMER_LAST_NAME,
> >
> DATE_OF_BIRTH,GENDER,MARITAL_STATUS,MARRIED_TO,LOCALE_ID,PRO FILE_PHOTO_PATH,STATUS,SKIP_STEP,LAST_MOD_TIME,LAST_MOD_BY
> > )
> >
> >
> >
> VALUES(old.CONSUMER_ID,old.CONSUMER_TYPE_ID,old.ENTERPRISE_U RL_ID,old.CONSUMER_FIRST_NAME,old.CONSUMER_MIDDLE_INITIAL,
> >
> >
> old.CONSUMER_LAST_NAME,old.DATE_OF_BIRTH,old.GENDER,old.MARI TAL_STATUS,old.MARRIED_TO,old.LOCALE_ID,old.PROFILE_PHOTO_PA TH,
> > old.STATUS,old.SKIP_STEP,old.LAST_MOD_TIME,old.LAST_MOD_BY ); end;
> >
> > But when i see the trigger using show trigger command on mysql front it
> > doesn't show and when i run the stament to hit the trigger it gives the
> > error "SQL execution erro # 1227. Response from the database: Access
> denied
> > ; you need the SUPER privilege for this operation".
> >
> > But this user has all privilege. Why it is not executing ?
> >
> > Thanks in advance.
> >
> > Regards
> > Jeetendra Ranjan
>

--0016368e22af89bc9a047b508adb--