CODEWITHSUNDEEP
snowflake-cloud-data-platform
Runar Persen
Runar Persen

Reputation: 1

Switch role in Snowflake Procedure

Cant switch role in Javascript Procedure.

In my Snowflake Javascipt Procedure i try the command:

snowflake.execute( {sqlText: "use role sysadmin" });

Stored procedure execution error:

Unsupported statement type 'USE'.
At Statement.execute, line 49 position 13

Any sugestions?

Upvotes: 0

Views: 653

Answers (1)

Sanjeev
Sanjeev

Reputation: 1

Try executing it as caller:

CREATE OR REPLACE PROCEDURE useroletest()
RETURNS VARCHAR
LANGUAGE JAVASCRIPT
EXECUTE AS CALLER
AS 
$$

snowflake.createStatement( {sqlText: `USE ROLE SECURITYADMIN;`} ).execute();

$$

;

Upvotes: 0

Related Questions