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.