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

Granted to PUBLIC

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

            Transition Time In Source Status Execution Times
            Sergei Golubchik made transition -
            Open In Review
            		228d 6h 49m 1
            Oleksandr Byelkin made transition -
            In Progress Stalled
            		400d 2h 27m 2
            Oleksandr Byelkin made transition -
            In Progress In Review
            		286d 1h 6m 1
            Sergei Golubchik made transition -
            In Review Stalled
            		128d 4h 56m 2
            Oleksandr Byelkin made transition -
            Stalled In Progress
            		2183d 41m 4
            Sergei Golubchik made transition -
            In Progress In Testing
            		21d 10h 10m 1
            Angelique Sklavounos (Inactive) made transition -
            In Testing Stalled
            		35d 10m 1
            Sergei Golubchik made transition -
            Stalled Closed
            		7d 14h 27m 1

            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.