![]() In MySQL 8.0, if a user does not have the GRANT CREATE ROUTINE and ALTER ROUTINE permissions, Liquibase Pro cannot get procedure or function bodies. In MySQL 5.7, if a user does not have the SELECT ON mysql.proc permission, Liquibase Pro cannot get procedure or function bodies. In MySQL, set the following permissions required to capture procedures, functions, triggers, views, and check constraints: GRANT CREATE ROUTINE, ALTER ROUTINE ON your_db.* TO CREATE VIEW, SHOW VIEW ON your_db.* TO TRIGGER ON your_db.* to ALTER, CREATE, DELETE, DROP, INDEX, INSERT, SELECT ,REFERENCES, UPDATE on ON your_db.* TO PROCESS ON *.* TO SELECT ON *.* TO For more information about GRANT statement in MySQL 8.0, which grants privileges to MySQL user accounts, see GRANT Statement.Īdditionally, there are a few configuration requirements and notes: Minimum GRANTs for Liquibase Pro with MySQL 8.0 (Standard or RDS) In MySQL, set the following permissions required to capture procedures, functions, triggers, views, and check constraints: GRANT SELECT ON mysql.proc TO SELECT, SHOW VIEW, CREATE VIEW ON your_db.* TO CREATE ROUTINE, ALTER ROUTINE ON your_db.* TO TRIGGER ON your_db.* TO ALTER, CREATE, DELETE, DROP, INDEX, INSERT, REFERENCES, SELECT, UPDATE ON your_db.* TO PROCESS ON *.* TO For more information about GRANT statement in MySQL 5.7, which grants privileges to MySQL user accounts, see GRANT Statement. Minimum GRANTs for Liquibase Pro with MySQL 5.7 (Standard or RDS) Liquibase Pro Stored Logic and GRANTs in MySQL 5.7 and MySQL 8.0Īs permissions are different for MySQL 5.7 and MySQL 8.0, follow the information for the version that you are using. To see procedures, functions, triggers, views, and check constraints, you need to set user’s GRANTs. The lack of permissions results in the changelog that cannot be used for STOLO exports. In this case, the generate-changelog, diff-changelog, and snapshot commands run by a user who is not the DEFINER cannot check the procedures, functions, triggers, views, and check constraints because of permissions that are not controlled. When using Liquibase Pro stored logic with MySQL, MySQL has a default feature that limits access to stored logic bodies when the user requesting access is not the user who created them.Īlso, the access can be limited when the user is not the DEFINER in MySQL. Liquibase Pro and MySQL GRANT Best Practices
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |