I want to make multiple users and allow them to change procedures,functions and triggers in same DB. There must be user
devel for developers and
admin for admin, both can change developers DB, but admin is not
root, i.e. he can't change everything, only some databases.
admin have following permissions:
GRANT ALL PRIVILEGES ON some_db_prefix%.* TO 'admin'@'%' WITH GRANT OPTION
All fine except definers in triggers and procedures. If I set definer in database to
devel@'%', i can't edit procedures as
root user can, of course.
How can I allow to modify triggers,functions and procedures to multiple users?
UPD: I can't edit procedures as
admin even when definer is
UPD2: MySQL version:
Server version: 5.6.23-ndb-7.4.5-cluster-gpl-log MySQL Cluster Community Server (GPL)
UPD 3: (moved to new question Allow multiple users to see procedures and functions )
UPD 4: Manuals say that only way to change body of procedure is to drop it and create new. So, I can do it, and my question is incorrect, I want not only change functions/procedures using different users, but also see body (code) of funtions/procedures. That's why I have created new question.