Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.elementum.io/llms.txt

Use this file to discover all available pages before exploring further.

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

​
Step 1: Install the License Patrol native app

  1. In the Snowflake Marketplace, navigate to the License Patrol listing.
  2. Select the app and click Get to install it.
  3. Using the ACCOUNTADMIN role, select Manage Access.
  4. 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.