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

Make CREATE/DROP/SET ROLE usable in stored programs

Details

    Description

      CREATE/DROP/SET ROLE work in stored procedures. However, they can only be used with a constant role name. To make the role name variable, IMO you could do one of these things:
      a) Allow use of variables:
      CREATE ROLE local_var, @user_var;
      b) Allow CREATE/DROP in prepared statements. Currently they are not allowed.

      Attachments

        Issue Links

          includes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-9443 Roles aren't supported in prepared statements

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            serg Sergei Golubchik added a comment -

            it should probably be done both for users and roles

            serg Sergei Golubchik added a comment - it should probably be done both for users and roles
            f_razzoli Federico Razzoli added a comment -

            MDEV-9443 has been fixed. So probably this task is much less important now.

            Not useless, though: having to use a prepared statement to execute a certain statement in a procedure can be annoying.

            f_razzoli Federico Razzoli added a comment - MDEV-9443 has been fixed. So probably this task is much less important now. Not useless, though: having to use a prepared statement to execute a certain statement in a procedure can be annoying.
            serg Sergei Golubchik added a comment -

            Yes, allowing existing syntax to be prepared is one thing (it's MDEV-9443).
            Supporting expressions for user and role names (variables and placeholders are expressions) is a different task.
            Not useless, I agree.

            serg Sergei Golubchik added a comment - Yes, allowing existing syntax to be prepared is one thing (it's MDEV-9443 ). Supporting expressions for user and role names (variables and placeholders are expressions) is a different task. Not useless, I agree.

            People

              Unassigned Unassigned
              f_razzoli Federico Razzoli
              Votes:
              1 Vote for this issue
              Watchers:
              2 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.