create procedure p1 () select 1;
create role r1, r2;
grant r1 to r2;
create user foo@localhost;
grant r2 to foo@localhost;
grant execute on procedure test.p1 to r1;
#grant alter routine on procedure test.p1 to r2;
set role r2;
this test succeeds, call p1() is allowed. but if grant alter routine is uncommented, the test fails.
DENY clause for access control a.k.a. "negative grants"
Role grant commands do not propagate all grants
Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.