MDEV-6918 Create a way to see a user's default role MDEV-7288 USER/ROLE: CREATE OR REPLACE, CREATE IF NOT EXISTS, DROP IF EXISTS MDEV-5214 Status variables for number of global/db/table/column/role grants MDEV-5210 Default role
MDEV-516610.0-roles does not build with BUILD/compile-pentium-debug-max-no-ndb
Closed
MDEV-5170Assertion `(&(&acl_cache->lock)->m_mutex)->count > 0 && pthread_equal(pthread_self(), (&(&acl_cache->lock)->m_mutex)->thread)' fails after restarting server with a pre-created role grants
Closed
MDEV-5172safe_mutex: Trying to lock mutex when the mutex was already locked on using a role and I_S role tables
Closed
MDEV-5175Revoking a role does not revoke corresponding grants from open sessions
Closed
MDEV-5221User auto-creation does not work upon GRANT <role>
Closed
MDEV-5223Server crashes on REVOKE ... from CURRENT_ROLE
Closed
MDEV-5225Server crashes on CREATE USER|ROLE CURRENT_ROLE or DROP ROLE CURRENT_ROLE
Closed
MDEV-5227Resolve the ambiguity between user and role names as mentioned in MDEV-4397
Closed
MDEV-5228Incorrect message test on a failed attempt to revoke grants from a role
Open
MDEV-5237Minor inconsistency between current_role and I_S.enabled_roles
Closed
MDEV-5238Server crashes in find_role_grant_pair on SHOW GRANTS for an anonymous user
Closed
MDEV-5668Assertion `granted_role->is_role()' fails on granting role with empty name
Closed
MDEV-5669Possible inconsistencies or lack of documentation in role privilege grants and propogation
Closed
MDEV-5771Privileges acquired via roles depend on the order of granting
Closed
MDEV-5772Granting multiple roles in single statement does not work
Open
MDEV-8609Server crashes in is_invalid_role_name on reloading ACL with a blank role name
Closed
MDEV-8612Assertion `granted_role->is_role()' failed in mysql_grant_role on granting role starting with 0-character
Confirmed
MDEV-8614Assertion `status == 0' failed in add_role_user_mapping_action on RENAME USER
Closed
MDEV-8616Inconsistent behavior of GRANT/REVOKE PROXY with roles
Open
MDEV-8627SHOW GRANTS does not work for a replicated role (throws 'There is no such grant defined for user ...')
Closed
MDEV-8638REVOKE ALL PRIVILEGES, GRANT OPTION FROM CURRENT_ROLE breaks replication
Closed
MDEV-8174Assertion `status == 0' failed in add_role_user_mapping_action
Closed
MDEV-8176Overuse/misuse of ERROR 1959 (OP000): Invalid role specification
~elenst/+junk/mariadb-toolbox/grammars/users_and_roles.yy
~elenst/+junk/mariadb-toolbox/grammars/10.1-users_and_roles.yy
Requires changes in RQG to have system (root) dsns and the "normal" user dsns.
Elena Stepanova
added a comment - - edited ~elenst/+junk/mariadb-toolbox/grammars/users_and_roles.yy
~elenst/+junk/mariadb-toolbox/grammars/10.1-users_and_roles.yy
Requires changes in RQG to have system (root) dsns and the "normal" user dsns.
People
Elena Stepanova
Sergei Golubchik
Votes:
0Vote for this issue
Watchers:
2Start watching this issue
Dates
Created:
Updated:
Resolved:
Git Integration
Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.
{"report":{"fcp":2028.0999999046326,"ttfb":1062.5,"pageVisibility":"visible","entityId":26101,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"0986c62e-ce44-4ff6-9326-d589ff588a9e","navigationType":0,"readyForUser":2118.399999976158,"redirectCount":0,"resourceLoadedEnd":2908.7999999523163,"resourceLoadedStart":1080.6999999284744,"resourceTiming":[{"duration":415.7000000476837,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":1080.6999999284744,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1080.6999999284744,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1496.3999999761581,"responseStart":0,"secureConnectionStart":0},{"duration":415.7999999523163,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2cib/820016/12ta74/2bf333562ca6724060a9d5f1535471f6/_/download/contextbatch/css/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true","startTime":1081,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1081,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1496.7999999523163,"responseStart":0,"secureConnectionStart":0},{"duration":482.2000000476837,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":1081.1999999284744,"connectEnd":1081.1999999284744,"connectStart":1081.1999999284744,"domainLookupEnd":1081.1999999284744,"domainLookupStart":1081.1999999284744,"fetchStart":1081.1999999284744,"redirectEnd":0,"redirectStart":0,"requestStart":1081.1999999284744,"responseEnd":1563.3999999761581,"responseStart":1563.3999999761581,"secureConnectionStart":1081.1999999284744},{"duration":554.3999999761581,"initiatorType":"script","name":"https://jira.mariadb.org/s/2d8175ec2fa4c816e8023260bd8c1786-CDN/lu2cib/820016/12ta74/2bf333562ca6724060a9d5f1535471f6/_/download/contextbatch/js/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true","startTime":1082.3999999761581,"connectEnd":1082.3999999761581,"connectStart":1082.3999999761581,"domainLookupEnd":1082.3999999761581,"domainLookupStart":1082.3999999761581,"fetchStart":1082.3999999761581,"redirectEnd":0,"redirectStart":0,"requestStart":1082.3999999761581,"responseEnd":1636.7999999523163,"responseStart":1636.7999999523163,"secureConnectionStart":1082.3999999761581},{"duration":419.90000009536743,"initiatorType":"script","name":"https://jira.mariadb.org/s/a9324d6758d385eb45c462685ad88f1d-CDN/lu2cib/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":1082.5999999046326,"connectEnd":1082.5999999046326,"connectStart":1082.5999999046326,"domainLookupEnd":1082.5999999046326,"domainLookupStart":1082.5999999046326,"fetchStart":1082.5999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":1082.5999999046326,"responseEnd":1502.5,"responseStart":1502.5,"secureConnectionStart":1082.5999999046326},{"duration":441.89999997615814,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":1082.6999999284744,"connectEnd":1082.6999999284744,"connectStart":1082.6999999284744,"domainLookupEnd":1082.6999999284744,"domainLookupStart":1082.6999999284744,"fetchStart":1082.6999999284744,"redirectEnd":0,"redirectStart":0,"requestStart":1082.6999999284744,"responseEnd":1524.5999999046326,"responseStart":1524.5999999046326,"secureConnectionStart":1082.6999999284744},{"duration":557.0999999046326,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":1083,"connectEnd":1083,"connectStart":1083,"domainLookupEnd":1083,"domainLookupStart":1083,"fetchStart":1083,"redirectEnd":0,"redirectStart":0,"requestStart":1083,"responseEnd":1640.0999999046326,"responseStart":1640.0999999046326,"secureConnectionStart":1083},{"duration":624.6000000238419,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2cib/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":1083.0999999046326,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1083.0999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1707.6999999284744,"responseStart":0,"secureConnectionStart":0},{"duration":557.5,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":1083.1999999284744,"connectEnd":1083.1999999284744,"connectStart":1083.1999999284744,"domainLookupEnd":1083.1999999284744,"domainLookupStart":1083.1999999284744,"fetchStart":1083.1999999284744,"redirectEnd":0,"redirectStart":0,"requestStart":1083.1999999284744,"responseEnd":1640.6999999284744,"responseStart":1640.6999999284744,"secureConnectionStart":1083.1999999284744},{"duration":624.2999999523163,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2cib/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/css/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.css?jira.create.linked.issue=true","startTime":1083.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1083.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1707.7999999523163,"responseStart":0,"secureConnectionStart":0},{"duration":557.7000000476837,"initiatorType":"script","name":"https://jira.mariadb.org/s/5d5e8fe91fbc506585e83ea3b62ccc4b-CDN/lu2cib/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/js/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.js?jira.create.linked.issue=true&locale=en","startTime":1083.5999999046326,"connectEnd":1083.5999999046326,"connectStart":1083.5999999046326,"domainLookupEnd":1083.5999999046326,"domainLookupStart":1083.5999999046326,"fetchStart":1083.5999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":1083.5999999046326,"responseEnd":1641.2999999523163,"responseStart":1641.2999999523163,"secureConnectionStart":1083.5999999046326},{"duration":1451.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":1086.6999999284744,"connectEnd":1086.6999999284744,"connectStart":1086.6999999284744,"domainLookupEnd":1086.6999999284744,"domainLookupStart":1086.6999999284744,"fetchStart":1086.6999999284744,"redirectEnd":0,"redirectStart":0,"requestStart":1086.6999999284744,"responseEnd":2538.1999999284744,"responseStart":2538.1999999284744,"secureConnectionStart":1086.6999999284744},{"duration":1822.1000000238419,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":1086.6999999284744,"connectEnd":1086.6999999284744,"connectStart":1086.6999999284744,"domainLookupEnd":1086.6999999284744,"domainLookupStart":1086.6999999284744,"fetchStart":1086.6999999284744,"redirectEnd":0,"redirectStart":0,"requestStart":1086.6999999284744,"responseEnd":2908.7999999523163,"responseStart":2908.7999999523163,"secureConnectionStart":1086.6999999284744},{"duration":825.6999999284744,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":1718.5,"connectEnd":1718.5,"connectStart":1718.5,"domainLookupEnd":1718.5,"domainLookupStart":1718.5,"fetchStart":1718.5,"redirectEnd":0,"redirectStart":0,"requestStart":1718.5,"responseEnd":2544.1999999284744,"responseStart":2544.1999999284744,"secureConnectionStart":1718.5}],"fetchStart":0,"domainLookupStart":795,"domainLookupEnd":843,"connectStart":843,"connectEnd":863,"secureConnectionStart":852,"requestStart":863,"responseStart":1062,"responseEnd":1084,"domLoading":1066,"domInteractive":2938,"domContentLoadedEventStart":2938,"domContentLoadedEventEnd":2986,"domComplete":3559,"loadEventStart":3559,"loadEventEnd":3560,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":2914},{"name":"bigPipe.sidebar-id.end","time":2914.899999976158},{"name":"bigPipe.activity-panel-pipe-id.start","time":2915},{"name":"bigPipe.activity-panel-pipe-id.end","time":2915.899999976158},{"name":"activityTabFullyLoaded","time":3001.399999976158}],"measures":[],"correlationId":"50dc083c04cc52","effectiveType":"4g","downlink":9.6,"rtt":0,"serverDuration":139,"dbReadsTimeInMs":39,"dbConnsTimeInMs":51,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
~elenst/+junk/mariadb-toolbox/grammars/users_and_roles.yy
~elenst/+junk/mariadb-toolbox/grammars/10.1-users_and_roles.yy
Requires changes in RQG to have system (root) dsns and the "normal" user dsns.