Secure Postgres RLS Policy

Write a comprehensive Postgres Row Level Security (RLS) setup for the table [TableName].

Requirements

1. Enable RLS

ALTER TABLE [TableName] ENABLE ROW LEVEL SECURITY;

2. Create Policies

Create policies for all operations:

• SELECT
• INSERT
• UPDATE
• DELETE

3. Policy Rules

• Allow [RoleName] to perform [Actions]
• On rows where [Condition]

4. Documentation

• Add helpful comments explaining each policy
• Explain the security model

5. Edge Cases

Consider and handle:

• NULL values
• Cascading deletes
• Permission inheritance

6. Testing

• Include example queries showing how the policies work
• Demonstrate both allowed and denied operations

Security Requirements

• Production-ready
• Secure by default
• Follow principle of least privilege