Issue #3639302: Coordinate scoped signed grants with host transactions

Closes #3639302

Scoped signed grants need to commit or roll back together with a host application’s related writes. This adds an optional transaction participant, bounded grant/state inspection, and scoped revocation while preserving default behavior for fields that have not enrolled.

File Gate owns standalone native SQL transactions. Participants join the supplied transaction, execute the effect once, and cannot replace or prematurely finish the transaction. Protected fields continue to deny private-file access when gate configuration is missing or no longer qualified. Emergency cleanup preserves typed revocation evidence and cannot downgrade a coordinated revocation.

Validation includes PostgreSQL and MySQL kernel tests, independent concurrent workers, transaction rollback and rebound failures, actual private-file delivery, Assurance identity checks, and default unenrolled behavior. The focused suites passed 7 tests / 113 assertions on PostgreSQL, 6 / 92 on MySQL, and 41 / 440 on SQLite. The final generated-proxy lookup correction also passed focused static analysis and 2 PostgreSQL tests / 44 assertions.

Review and CI remain required before merge.

Merge request reports

Loading
Loading