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

Granting roles to account does not work at all.

    XMLWordPrintable

    Details

      Description

      I created 3 roles:

      create role vdo_dev, vdo_admin;

      I have my own user, called andries, as well as schema called vdo_workflow

      I granted access to all elements within the vdo_workflow schema to vdo_dev:

      grant ALL on vdo_workflow.* to vdo_dev;

      flush privileges;

      show grants for vdo_dev and user andries emits the following results:

      +--------------------------------------------------------------------------------------------------------+
      | Grants for andries@%                                                                                   |
      +--------------------------------------------------------------------------------------------------------+
      | GRANT vdo_dev TO 'andries'@'%'                                                                         |
      

      +-------------------------------------------------------+
      | Grants for vdo_dev                                    |
      +-------------------------------------------------------+
      | GRANT USAGE ON *.* TO 'vdo_dev'                       |
      | GRANT ALL PRIVILEGES ON `vdo_workflow`.* TO 'vdo_dev' |
      +-------------------------------------------------------+
      
      

      When I logged in as andries, and inspect the role I still get null:

      MariaDB [(none)]> select current_role;
      +--------------+
      | current_role |
      +--------------+
      | NULL         |
      +--------------+
      1 row in set (0.00 sec)
       
      MariaDB [(none)]> select current_user;
      +--------------+
      | current_user |
      +--------------+
      | andries@%    |
      +--------------+
      1 row in set (0.00 sec)
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              andriesfc Andries Spies
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: