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

Privilege aliases are missing from SHOW PRIVILEGES

    XMLWordPrintable

Details

    Description

      MariaDB Server currently supports several privilege aliases:

      • READ ONLY ADMIN is an alias for READ_ONLY ADMIN.
      • REPLICATION REPLICA is an alias for REPLICATION SLAVE.
      • REPLICATION REPLICA ADMIN is an alias for REPLICATION SLAVE ADMIN.
      • REPLICATION CLIENT is an alias for BINLOG MONITOR.

      However, these privilege aliases do not seem to be present in SHOW PRIVILEGES:

      MariaDB [(none)]> SHOW PRIVILEGES;
      +--------------------------+---------------------------------------+--------------------------------------------------------------------+
      | Privilege                | Context                               | Comment                                                            |
      +--------------------------+---------------------------------------+--------------------------------------------------------------------+
      | Alter                    | Tables                                | To alter the table                                                 |
      | Alter routine            | Functions,Procedures                  | To alter or drop stored functions/procedures                       |
      | Create                   | Databases,Tables,Indexes              | To create new databases and tables                                 |
      | Create routine           | Databases                             | To use CREATE FUNCTION/PROCEDURE                                   |
      | Create temporary tables  | Databases                             | To use CREATE TEMPORARY TABLE                                      |
      | Create view              | Tables                                | To create new views                                                |
      | Create user              | Server Admin                          | To create new users                                                |
      | Delete                   | Tables                                | To delete existing rows                                            |
      | Delete history           | Tables                                | To delete versioning table historical rows                         |
      | Drop                     | Databases,Tables                      | To drop databases, tables, and views                               |
      | Event                    | Server Admin                          | To create, alter, drop and execute events                          |
      | Execute                  | Functions,Procedures                  | To execute stored routines                                         |
      | File                     | File access on server                 | To read and write files on the server                              |
      | Grant option             | Databases,Tables,Functions,Procedures | To give to other users those privileges you possess                |
      | Index                    | Tables                                | To create or drop indexes                                          |
      | Insert                   | Tables                                | To insert data into tables                                         |
      | Lock tables              | Databases                             | To use LOCK TABLES (together with SELECT privilege)                |
      | Process                  | Server Admin                          | To view the plain text of currently executing queries              |
      | Proxy                    | Server Admin                          | To make proxy user possible                                        |
      | References               | Databases,Tables                      | To have references on tables                                       |
      | Reload                   | Server Admin                          | To reload or refresh tables, logs and privileges                   |
      | Binlog admin             | Server                                | To purge binary logs                                               |
      | Binlog monitor           | Server                                | To use SHOW BINLOG STATUS and SHOW BINARY LOG                      |
      | Replication master admin | Server                                | To monitor connected slaves                                        |
      | Replication slave admin  | Server                                | To start/monitor/stop slave and apply binlog events                |
      | Replication slave        | Server Admin                          | To read binary log events from the master                          |
      | Select                   | Tables                                | To retrieve rows from table                                        |
      | Show databases           | Server Admin                          | To see all databases with SHOW DATABASES                           |
      | Show view                | Tables                                | To see views with SHOW CREATE VIEW                                 |
      | Shutdown                 | Server Admin                          | To shut down the server                                            |
      | Super                    | Server Admin                          | To use KILL thread, SET GLOBAL, CHANGE MASTER, etc.                |
      | Trigger                  | Tables                                | To use triggers                                                    |
      | Create tablespace        | Server Admin                          | To create/alter/drop tablespaces                                   |
      | Update                   | Tables                                | To update existing rows                                            |
      | Set user                 | Server                                | To create views and stored routines with a different definer       |
      | Federated admin          | Server                                | To execute the CREATE SERVER, ALTER SERVER, DROP SERVER statements |
      | Connection admin         | Server                                | To bypass connection limits and kill other users' connections      |
      | Read_only admin          | Server                                | To perform write operations even if @@read_only=ON                 |
      | Usage                    | Server Admin                          | No privileges - allow connect only                                 |
      +--------------------------+---------------------------------------+--------------------------------------------------------------------+
      39 rows in set (0.008 sec)
      

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              GeoffMontee Geoff Montee (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.