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

            Activity

              People

              Assignee:
              sanja Oleksandr Byelkin
              Reporter:
              serg Sergei Golubchik
              Votes:
              0 Vote for this issue
              Watchers:
              8 Start watching this issue

                Dates

                Created:
                Updated: