2

I have problem with one of my client

Provided super privileges to the client James on 'Reports ' database , but the problem is the client need 'SUPER' privileges to the reports DB in order to create and maintain my Functions. So I'm still unable to move forward...

BUT, I still need SUPER privileges to the reports DB in order to create and maintain my Functions. So I'm still unable to move forward... (This is what client responding , he can login but he can't create nor maintain functions on reports db server )

After providing super privileges the client cant maintenance any of this functions nor he can create functions , how to work on this .

1
  • The ALTER ROUTINE privilege is needed to maintain functions.
    – Barmar
    Apr 18, 2013 at 6:16

1 Answer 1

1

To modify functions and stored procedures, you need the ALTER ROUTINE privilege. If binary logging is enabled, you may also require the SUPER privilege.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.