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

Granting roles to account does not work at all.

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

          blocks

          Bug - A problem which impairs or prevents the functions of the product. MDEV-10463 Granted as a whole to roles, databases are not shown in SHOW DATABASES

          • Major - Major loss of function.
          • Closed

          Activity

            elenst Elena Stepanova added a comment -

            To enable the role, you need to run SET ROLE vdo_dev. It will be effective for the current session.
            Alternatively, if you don't want to run it for every session, you can run SET DEFAULT ROLE vdo_dev.
            See documentation for more details.

            elenst Elena Stepanova added a comment - To enable the role, you need to run SET ROLE vdo_dev . It will be effective for the current session. Alternatively, if you don't want to run it for every session, you can run SET DEFAULT ROLE vdo_dev . See documentation for more details.

            People

              Unassigned Unassigned
              andriesfc Andries Spies
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.