Make CREATE/DROP/SET ROLE usable in stored programs

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.