Is SUPER privilege required only when enabling logging?

[ken]

Is SUPER privilege required only when enabling logging? I prefer to only give my MySQL user to minimum privileges it needs to do it's job. I'd like to remove the SUPER privilege once logging has been enabled,

Thanks,
Ken

[Donald Lobo]

when u add/delete new custom fields / groups, we need the trigger privilege again. might be worth keeping it for now

note that in mysql 5.1 trigger is yet another privilege. so no need for super

lobo

[davej]

Testing with Civi 3.4.1 and MySQL 5.0.51, I tried granting SUPER privilege, enabling logging, revoking SUPER, then editing a contact. The log_ tables got created OK but when I tried editing a contact, I got this error:

UPDATE  civicrm_contact  SET contact_type = 'Individual' , contact_sub_type = NULL , do_not_email = 1 , do_not_phone = 0 , do_not_mail = 0 , do_not_sms = 0 , do_not_trade = 0 , is_opt_out = 1 , external_identifier = NULL , sort_name = 'Technical, Circle' , display_name = 'Circle Technical' , nick_name = NULL , preferred_communication_method = '' , preferred_language = 'en_GB' , preferred_mail_format = 'Both' , source = NULL , first_name = 'Circle' , middle_name = NULL , last_name = 'Technical' , suffix_id = NULL , email_greeting_id = 1 , email_greeting_custom = NULL , postal_greeting_id = 1 , postal_greeting_custom = NULL , addressee_id = 1 , addressee_custom = NULL , job_title = NULL , gender_id = NULL , birth_date = NULL , is_deceased = 0   WHERE (  civicrm_contact.id = 2 )   [nativecode=1227 ** Access denied; you need the SUPER privilege for this operation]

Not good news for those on 5.0 .

Dave J