84 lines
4.0 KiB
Markdown
84 lines
4.0 KiB
Markdown
# Changelog
|
|
|
|
All notable changes to this project will be documented in this file.
|
|
|
|
The format is based on [Keep a Changelog](https://keepachangelog.com/en/1.0.0/),
|
|
and this project adheres to [Semantic Versioning](https://semver.org/spec/v2.0.0.html).
|
|
|
|
## [1.0.2] - 2026-11-06
|
|
|
|
### Fixed
|
|
- `is_allowed()` with a NULL user id failed with a NOT NULL violation on
|
|
`auth_cache` instead of answering. `is_allowed()` and `is_allowed_nocache()`
|
|
now return FALSE for a NULL user, the answer `rls_check()` already gave.
|
|
Decisions for real users are unchanged.
|
|
|
|
## [1.0.1] - 2026-10-14
|
|
|
|
### Fixed
|
|
- `is_allowed_nocache()` (and so every uncached `is_allowed()`) resolved the
|
|
user's roles once per row of the whole `rules` table, calling
|
|
`get_comprehensive_roles()` and `org_in_scope()` for every rule of every
|
|
tenant: about 240 ms per decision with 2376 rules across 27 orgs. Roles are
|
|
now resolved once per org where the user can hold one and that has a rule for
|
|
the requested activity and view, and matching rules are read through those
|
|
(org, role) pairs; `org_in_scope()` runs once per (org, scope) pair. Cost no
|
|
longer grows with other tenants' rules. Decisions are unchanged, checked
|
|
against the 1.0.0 implementation on a randomized fixture
|
|
(`tests/17_is_allowed_equivalence.sql`).
|
|
- `tools/bump_version.sh` no longer rewrites the PGXN `meta-spec` version in
|
|
`META.json`.
|
|
|
|
## [1.0.0] - 2026-07-25
|
|
|
|
### Added
|
|
- First stable release of the Multi-OrBAC PostgreSQL extension
|
|
- Complete Multi-OrBAC implementation based on CNRS research paper
|
|
- Core features:
|
|
- Organization-centric access control
|
|
- Role-based abstraction with organizational scope
|
|
- Activity and view abstractions
|
|
- Context-based rule evaluation
|
|
- Four deontic modalities (permission, prohibition, obligation, recommendation)
|
|
- Prohibition precedence over permissions
|
|
- Multi-organization support
|
|
- Advanced features:
|
|
- Organization, role, activity, and view hierarchies with transitive closure
|
|
- Temporal delegation with time bounds
|
|
- Temporal constraints on rules with validity periods (valid_from, valid_until)
|
|
- Negative role assignments
|
|
- Separation of Duty (SoD) constraints
|
|
- Role cardinality constraints (min/max users)
|
|
- Derived roles (computed via functions)
|
|
- Cross-organizational rules with temporal support
|
|
- Administration rules (meta-policies)
|
|
- Audit logging for security-critical operations
|
|
- Audit logging system:
|
|
- Generic audit trigger for tracking INSERT/UPDATE/DELETE operations
|
|
- Comprehensive audit log with JSONB support for before/after states
|
|
- Helper functions: `enable_audit()`, `disable_audit()`
|
|
- Field-level change tracking
|
|
- Client connection metadata capture (IP, application name, session user)
|
|
- Policy DSL with idempotent compiler
|
|
- RLS helper functions for PostgREST integration
|
|
- Comprehensive test suite with 20 test scenarios
|
|
- Complete documentation
|
|
- Build and installation automation (Makefile, install.sh)
|
|
- Unattributed (no-org) object support:
|
|
- Org target vocabulary shared by every rule kind: a specific organization,
|
|
`unattributed` (objects with no org), or `all` (every org, unattributed included)
|
|
- `rules.scope` values `unattributed` and `all`
|
|
- `user_rules.org_id` accepts NULL to target unattributed objects
|
|
- `org_in_scope()` partitions the two object classes: `unattributed` matches only
|
|
a NULL target, tree scopes never match one
|
|
- `morbac.has_permission(user, activity, view)` capability probe for UI gating
|
|
- `morbac.current_org_filter()` parses `morbac.org_ids` once into org UUIDs plus
|
|
the unattributed-bucket flag (a JSON `null` element requests it)
|
|
- `rls_check()` split by arity so NULL never carries two meanings:
|
|
`rls_check(activity, view)` for tables with no org column,
|
|
`rls_check(activity, view, row_org_id[, row_user_id])` for row-scoped tables
|
|
where a NULL `row_org_id` means the record is unattributed
|
|
|
|
[1.0.1]: https://github.com/crudylabs/pgmorbac/releases/tag/v1.0.1
|
|
[1.0.0]: https://github.com/crudylabs/pgmorbac/releases/tag/v1.0.0
|