Re: Need SUPER Privilidge for UPDATE?
Sounds like you have triggers on the table, see the DEFINER clause within this section of the manual: http://dev.mysql.com/doc/refman/5.0/en/create-trigger.html Triggers within 5.0 require the user (within the DEFINER clause, or executing the statement against the table when using CURRENT_USER) to have the SUPER privilege. Within 5.1 this moves to the TRIGGER privilege. That is probably the case, because I DO have 2 triggers on this table. However, I don't get the definer thing. Because, on the other database that this works on, there is no definer clause on the trigger that I can tell, and I don't know how to tell if I've given the user name that I'm using on the other database the SUPER privilege or not. How do I give a user the SUPER privilege? Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Need SUPER Privilidge for UPDATE?
Hi Jesse wrote: I have an ASP.NET app where I'm doing an update, and the user name that I'm using has the access to do an update. When I execute this command, I get the error, "#42000Access denied; you need the SUPER privilege for this operation". Following is my query: UPDATE Families SET LastName='a',FathersFirstName='a',MothersFirstName='a',Address1='a', Address2='',City='a',State='FL',Zip='a', Donation=0,HomePhone='a',FathersWorkPhone='',MothersWorkPhone='', FathersCell='',MothersCell='',EMail='[EMAIL PROTECTED]', UserName='a',Password='a' WHERE ID=157 I thought that the Password field might be an issue, but I've changed it to `password`, and that didn't make any difference. Neither did Families.Password, or Families.`Password`. Any ideas why I would be getting this error? This same exact query works fine on another database with the same structure and every thing. Sounds like you have triggers on the table, see the DEFINER clause within this section of the manual: http://dev.mysql.com/doc/refman/5.0/en/create-trigger.html Triggers within 5.0 require the user (within the DEFINER clause, or executing the statement against the table when using CURRENT_USER) to have the SUPER privilege. Within 5.1 this moves to the TRIGGER privilege. Best regards Mark -- Mark Leith, Support Engineer MySQL AB, Worcester, England, www.mysql.com Are you MySQL certified? www.mysql.com/certification -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Need SUPER Privilidge for UPDATE?
I have an ASP.NET app where I'm doing an update, and the user name that I'm using has the access to do an update. When I execute this command, I get the error, "#42000Access denied; you need the SUPER privilege for this operation". Following is my query: UPDATE Families SET LastName='a',FathersFirstName='a',MothersFirstName='a',Address1='a', Address2='',City='a',State='FL',Zip='a', Donation=0,HomePhone='a',FathersWorkPhone='',MothersWorkPhone='', FathersCell='',MothersCell='',EMail='[EMAIL PROTECTED]', UserName='a',Password='a' WHERE ID=157 I thought that the Password field might be an issue, but I've changed it to `password`, and that didn't make any difference. Neither did Families.Password, or Families.`Password`. Any ideas why I would be getting this error? This same exact query works fine on another database with the same structure and every thing. Using version 5.0.22-community-nt. with InnoDB tables. Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
