acl-security

What it does

This skill enables AI agents to manage Access Control Lists (ACLs) within Snowflake environments. It allows for the dynamic creation, modification, and revocation of data access permissions based on specific user roles or groups.

When to use it

• Enforce strict data governance by restricting sensitive table access to authorized personnel only.
• Automate the provisioning of temporary access rights for external analysts or contractors.
• Revoke permissions immediately when a user leaves the organization or changes roles.
• Implement least-privilege principles across large-scale Snowflake warehouses and databases.

Key capabilities

• Define granular privileges on Snowflake objects such as tables, views, and schemas.
• Apply access rules to specific users or security groups.
• Execute permission grants and revocations programmatically via AI agent commands.
• Maintain an audit trail of who has access to which data resources.

Example prompts

• "Create an ACL that grants SELECT permissions on the finance_reports table to the analysts group."
• "Revoke all privileges on the customer_data schema for user john_doe effective immediately."
• "Grant INSERT and UPDATE access on the orders table to the sales_team role with a comment explaining the scope."

Tips & gotchas

Ensure your AI agent has sufficient Snowflake administrative credentials before attempting ACL modifications, as incorrect permissions can lock out users. Always test permission changes in a non-production environment first to prevent accidental data exposure or access denial.