> ## 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.

# License Patrol with Snowflake CloudLink

> Additional setup steps for using License Patrol with your Snowflake CloudLink.

If your organization uses License Patrol, complete the standard [Snowflake CloudLink setup](/administration/connect-snowflake-to-elementum) first, then follow these additional steps to grant the License Patrol native app access to your data.

## Prerequisites

* Completed [Snowflake CloudLink setup](/administration/connect-snowflake-to-elementum), including the `ELEMENTUM` user, role, warehouse, and database.
* `ACCOUNTADMIN` role in Snowflake.
* Access to the [Snowflake Marketplace](https://app.snowflake.com/marketplace).

## 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.

```sql theme={null}
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

```sql theme={null}
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.

<CardGroup cols={2}>
  <Card title="Snowflake CloudLink setup" icon="snowflake" href="/administration/connect-snowflake-to-elementum">
    Return to the main Snowflake setup guide.
  </Card>

  <Card title="CloudLink Overview" icon="cloud" href="/administration/cloudlink-overview">
    Review CloudLink concepts and security.
  </Card>
</CardGroup>