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

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              f_razzoli Federico Razzoli
              Votes:
              1 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated: