Snippet

Table-Level Read Permission Delegation

Applying the principle of least privilege by granting specific query capabilities to database roles limits exposure and enforces secure access control boundaries.

snippet.sql

sql

GRANT SELECT ON public_financial_reports TO analyst_role;

Breakdown

GRANT SELECT ON public_financial_reports TO analyst_role;

Grants read-only access on the public_financial_reports table specifically to members assigned the analyst_role.

Previous snippet Next snippet

More Intermediate SQL exercises →

Table-Level Read Permission Delegation

Related