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]
