Skip to main content
Download these ready-to-use resources to accelerate your AnomalyArmor setup.

​
SQL Permission Templates

Minimal-privilege SQL scripts for granting AnomalyArmor read-only access to your databases. Each script includes:
  • Step-by-step setup instructions
  • Customizable placeholders
  • Verification queries
  • Cleanup commands

PostgreSQL

For PostgreSQL, RDS, Aurora, Supabase

Snowflake

Role and user setup for Snowflake

Databricks

Unity Catalog grants

​
How to Use

  1. Open the script page for your database
  2. Copy the SQL code
  3. Replace the placeholder values (marked with your_ prefix)
  4. Run as a database admin or owner
  5. Verify using the test queries provided
These scripts grant the minimum permissions required for AnomalyArmor. You can further restrict access by using the per-schema options in each script.

​
Security Best Practices

Create a dedicated user for AnomalyArmor rather than using personal accounts. This ensures:
  • Monitoring continues when employees leave
  • Clear audit trail of AnomalyArmor activity
  • Easy permission revocation if needed
AnomalyArmor only needs SELECT access for:
  • information_schema or equivalent for discovery
  • Tables you want to monitor for freshness
  • All scripts default to read-only access
For Snowflake and other databases that support it:
  • More secure than passwords
  • No password rotation required
  • Supports hardware security modules

​
Need Help?

PostgreSQL Guide

Detailed PostgreSQL setup instructions

Snowflake Guide

Detailed Snowflake setup instructions

Databricks Guide

Detailed Databricks setup instructions

Contact Support

Get help from our team