Categories:

System functions (System Information)

SYSTEM$HOLD_PRIVILEGE_ON_ACCOUNT

Indicates if a privilege has been granted to a Snowflake Native App. For example, providers can use this function in the setup script to check if the app has the necessary privileges to create an object.

Note

This system function can only be called by a Snowflake Native App.

语法

SYSTEM$HOLD_PRIVILEGE_ON_ACCOUNT('<privilege_name>')

实参

'privilege_name'

权限的名称。

返回

  • Returns TRUE if the app has been granted the specified privilege. Otherwise, returns FALSE.

示例

检查应用程序是否已获得 CREATE COMPUTE POOL 权限：

SELECT SYSTEM$HOLD_PRIVILEGE_ON_ACCOUNT('CREATE COMPUTE POOL');

检查应用程序是否已获得 IMPORTED PRIVILEGES ON SNOWFLAKE DB 权限：

SELECT SYSTEM$HOLD_PRIVILEGE_ON_ACCOUNT('IMPORTED PRIVILEGES ON SNOWFLAKE DB');