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,
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
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
Hi,
I have created the below trigger from root user with definer:
CREATE definer=`roo...@`` TRIGGER `CONSUMER_PROFILE_before_delete` BEFORE
DELETE ON CONSUMER_PROFILE FOR EACH ROW
begin
INSERT INTO
DELETED_CONSUMER_PROFILE(CONSUMER_ID,CONSUMER_TYPE_ID,ENTERPRISE_URL_ID,CONSUMER_FIRST_NAME,CON
