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.
Copy
Ask AI
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.