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

Make CREATE/DROP/SET ROLE usable in stored programs

    XMLWordPrintable

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

            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.