Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-5215

Granted to PUBLIC

    XMLWordPrintable

Details

    Description

      Implement the standard behavior for

      GRANT xxx TO PUBLIC;
      		 
      REVOKE xxx FROM PUBLIC;

      Also, this statement is supposed to work:

      SHOW GRANTS FOR PUBLIC;

      And these should not

      CREATE ROLE PUBLIC;
      		 
      DROP ROLE PUBLIC;
      		 
      SET ROLE PUBLIC;
      		 
      GRANT PUBLIC TO xxx;
      		 
      REVOKE PUBLIC FROM xxx;

      Note that

      SHOW GRANTS FOR xxx;

      should not list roles and privileges granted to PUBLIC (unless granted to xxx too), but

      SHOW GRANTS;

      should, arguably, list them.

      Attachments

        Issue Links

          blocks

          Task - A task that needs to be done. MDEV-20947 Use GRANT ... TO PUBLIC for default test database privileges

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-30085 ER_DBACCESS_DENIED_ERROR for Spider and Federated tables on test db

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-30154 Assertion `strcasecmp(rolename, public_name.str) || acl_public == role' failed in acl_update_role on GRANT ... TO PUBLIC

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed
          includes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-29752 SHOW GRANTS for PUBLIC should work for all users

          • Major - Major loss of function.
          • Closed
          is part of

          Task - A task that needs to be done. MDEV-29547 prepare 10.11.0 preview releases

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed
          relates to

          Task - A task that needs to be done. MDEV-4397 Roles

          • Major - Major loss of function.
          • Closed

          Activity

            People

              sanja Oleksandr Byelkin
              serg Sergei Golubchik
              Votes:
              1 Vote for this issue
              Watchers:
              14 Start 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.