Which commands are restricted in owner's rights stored procedures? (Choose two.)
Which commands are restricted in owner's rights stored procedures? (Choose two.)
In owner's rights stored procedures, there are several restrictions, including but not limited to session variables, session parameters, and the types of SQL statements that can be called. Specifically, the SHOW and DESCRIBE commands are restricted.
Owner’s rights stored procedures have several additional restrictions, besides the restrictions related to session variables and session parameters. These restrictions affect the following: The built-in functions that can be called from inside a stored procedure. Ability to execute ALTER USER statements. Monitoring stored procedures at execution time. SHOW and DESCRIBE commands. The types of SQL statements that can be called from inside a stored procedure.
A & E https://docs.snowflake.com/en/developer-guide/stored-procedure/stored-procedures-rights#:~:text=SHOW%20and-,DESCRIBE,-commands.