Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 2 down vote favorite

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 .

share|improve this question
The ALTER ROUTINE privilege is needed to maintain functions. – Barmar Apr 18 at 6:16

migrated from stackoverflow.com Apr 18 at 7:36

1 Answer

up vote 0 down vote

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

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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