Skip to main content
This article applies to these versions of LandingLens:
LandingLensLandingLens on Snowflake
✖✓
Many functions for managing require the LLENS_PUBLIC application role, including the ability to: Application roles can’t be granted directly to users, so you must grant LLENS_PUBLIC to an account role (or to another application role that is then granted to an account role). For example, the following commands create an account role called LANDINGLENS_EXTERNAL_ACCESS, grant that role to a user, and then grant the application role to the account role. Replace <user_name> with the name of the Snowflake user, and APP_NAME with the name of your LandingLens instance. To locate the name, go to Name of LandingLens Instance. 
CREATE ROLE LANDINGLENS_EXTERNAL_ACCESS;
GRANT ROLE LANDINGLENS_EXTERNAL_ACCESS TO USER <user_name>;
GRANT APPLICATION ROLE APP_NAME.LLENS_PUBLIC TO ROLE LANDINGLENS_EXTERNAL_ACCESS;
Only users with certain access can grant application roles. To see the requirements, refer to the Snowflake documentation.