Not all of the new features had a big announcement at Summit 2023, but that doesn’t mean we can’t highlight them!
This week we have a riddle for you to solve, and without spoiling everything, let’s see if you can solve the riddle from the initial code:
As you can see, we created 2 simple tables and a new role that we can select and insert from these tables. Now we want to use that role to create and execute a stored procedure to move data from table A to table B. HOWEVER, the role we have created does not have the CREATE PROCEDURE privilege.
Today’s challenge is to create and execute the following procedure without granting the CREATE PROCEDURE privilege:
Your solution should keep the procedure intact and this code snippet should be part of your solution:
CALL copy_to_table('table_a', 'table_b', 5);
Remember that if you want to participate:
Register as a Frosty Friday member. You can do so by clicking on the sidebar and then going to “SIGN UP” (note that joining our mailing list will not give you a Frosty Friday account).
Post your code on GitHub and make sure it is publicly accessible (see our guide if you don’t know how to do this).
Post the URL in the comments of the challenge.
If you have any technical questions you’d like to ask the community, you can do so here, in our thread dedicated to these challenges.