access-control

Design and implement RBAC for data warehouses and BI layers.

1|1|Updated Feb 27, 2026
One-click install
npx skills add https://github.com/nrakow/ae-skills-dev --skill access-control-nrakow
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: access-control
Source: https://github.com/nrakow/ae-skills-dev/tree/main/skills/access-control
Command: npx skills add https://github.com/nrakow/ae-skills-dev --skill access-control-nrakow

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

RBAC is essential to enforce least-privilege access across data warehouses and BI tools, reducing risk from over-privileged users and simplifying audits.

Core Features & Use Cases

  • RBAC design and role hierarchy aligned to data assets.
  • Snowflake masking policies, row-level security, and Terraform IAM configurations.
  • Use cases: grant least-privilege access to loaders/transformers/reporters and perform access audits.

Quick Start

Define roles in Snowflake, apply masking and row-level policies, and configure Terraform IAM to enforce least-privilege access.

Frequently Asked Questions about access-control

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I design RBAC with least-privilege access in Snowflake?▼

To design RBAC in Snowflake, define a role hierarchy aligned to data assets and apply least-privilege grants. This includes generating SQL role grants, masking policies, and row access policies to restrict loaders, transformers, and reporters securely.

How do I implement row-level security and data masking policies?▼

Implementing row-level security and data masking involves applying specific SQL policies to restrict data visibility. This process produces row access policies and masking policies within Snowflake to enforce granular least-privilege access controls.

Can I manage data warehouse access control using Terraform IAM?▼

Yes, you can manage data warehouse access control using Terraform IAM configurations. This approach generates Infrastructure as Code to enforce least-privilege access across Snowflake and BigQuery environments consistently.

What is the best way to audit role-based access control for BI tools?▼

The best way to audit RBAC for BI tools is to generate audit-ready checks alongside SQL role grants. This validates role hierarchies and access policies, ensuring least-privilege controls are maintained across data warehouses and BI layers.

Does this approach support both Snowflake and BigQuery environments?▼

Yes, this RBAC design approach supports both Snowflake and BigQuery environments. It scopes BI tool access and produces compatible configurations, including Terraform IAM, to enforce least-privilege access across these data warehouse platforms.