linkage/doctrine-row-level-security

v1.0.0 2023-08-02 01:18 UTC

This package is auto-updated.

Last update: 2024-10-30 05:16:11 UTC


README

A package to provide projects with Doctrine ORM PostgreSQL's Row Level Security features.

Usage

Add "#[RowLevelSecurity]" attribute to your Entity associated with table under Row Level Security.

There are 3 required options for RowLevelSecurity attribute:

  • name: a name for policy which should be attached to the table
  • role: a name of role which should be attached to RowLevelSecurity users
  • using: a sql clause which describes the role's access condition

Then you can use doctrine:migrations:diff or doctrine:schema:create command as usual. SQL to enable Row Level Security will appear in your migration files or be executed on schema creation.