License Patrol with Snowflake CloudLink

If your organization uses License Patrol, complete the standard Snowflake CloudLink setup first, then follow these additional steps to grant the License Patrol native app access to your data.

Prerequisites

Completed Snowflake CloudLink setup, including the ELEMENTUM user, role, warehouse, and database.
ACCOUNTADMIN role in Snowflake.
Access to the Snowflake Marketplace.

Step 1: Install the License Patrol native app

In the Snowflake Marketplace, navigate to the License Patrol listing.
Select the app and click Get to install it.
Using the ACCOUNTADMIN role, select Manage Access.
Add the ELEMENTUM role to the app’s access list.

Step 2: Grant required permissions

Run the following grants to give the License Patrol application access to the source tables it analyzes, and to give the ELEMENTUM role access to License Patrol’s app data.

USE ROLE ACCOUNTADMIN;

-- Grant database and schema access to the License Patrol application
GRANT USAGE ON DATABASE <YOUR_DATABASE> TO APPLICATION LICENSE_PATROL;
GRANT USAGE ON SCHEMA <YOUR_DATABASE>.<YOUR_SCHEMA> TO APPLICATION LICENSE_PATROL;

-- Grant access to relevant tables
GRANT SELECT ON TABLE <YOUR_DATABASE>.<YOUR_SCHEMA>.APPLICATION_LOGINS TO APPLICATION LICENSE_PATROL;
GRANT SELECT ON TABLE <YOUR_DATABASE>.<YOUR_SCHEMA>.EMPLOYEE_DATA TO APPLICATION LICENSE_PATROL;
GRANT SELECT ON TABLE <YOUR_DATABASE>.<YOUR_SCHEMA>.SOFTWARE_CONTRACTS TO APPLICATION LICENSE_PATROL;

-- Grant Elementum access to License Patrol data
GRANT SELECT ON TABLE LICENSEPATROL.APP_DATA.REVOCATION_EXCLUDE TO ROLE ELEMENTUM;

Replace <YOUR_DATABASE> and <YOUR_SCHEMA> with the database and schema that contain your License Patrol source tables.

Example with concrete values

USE ROLE ACCOUNTADMIN;

GRANT USAGE ON DATABASE HR_DB TO APPLICATION LICENSE_PATROL;
GRANT USAGE ON SCHEMA HR_DB.PUBLIC TO APPLICATION LICENSE_PATROL;

GRANT SELECT ON TABLE HR_DB.PUBLIC.APPLICATION_LOGINS TO APPLICATION LICENSE_PATROL;
GRANT SELECT ON TABLE HR_DB.PUBLIC.EMPLOYEE_DATA TO APPLICATION LICENSE_PATROL;
GRANT SELECT ON TABLE HR_DB.PUBLIC.SOFTWARE_CONTRACTS TO APPLICATION LICENSE_PATROL;

GRANT SELECT ON TABLE LICENSEPATROL.APP_DATA.REVOCATION_EXCLUDE TO ROLE ELEMENTUM;

Next steps

For setup or access questions, contact Elementum Support or your account representative.

Snowflake CloudLink setup

Return to the main Snowflake setup guide.

CloudLink Overview

Review CloudLink concepts and security.

Access

User Settings

Platform Administration

Connections

License Patrol with Snowflake CloudLink

Prerequisites

Step 1: Install the License Patrol native app

Step 2: Grant required permissions

Example with concrete values

Next steps

Snowflake CloudLink setup

CloudLink Overview

​Prerequisites

​Step 1: Install the License Patrol native app

​Step 2: Grant required permissions

​Example with concrete values

​Next steps

Snowflake CloudLink setup

CloudLink Overview

Prerequisites

Step 1: Install the License Patrol native app

Step 2: Grant required permissions

Example with concrete values

Next steps