Files
mtusi2026lab7/migrations/009_column_privileges.sql
mayorovasonya 7353ab97a6 Лаб7: mTLS, Argon2id, OpenBao и исследование отзыва worker
Майорова Софья, БВТ2301, на 5. Трек1. HTTPS/TLS/ACL,18 API tests,13 pipeline groups,3 compromise runs,clean clone,persistence. Original tests/API contract preserved; residual CVE triage in REPORT/security.
2026-11-20 14:48:26 +03:00

14 lines
526 B
SQL

REVOKE UPDATE ON attachments, attachment_jobs FROM worker_role, dispatcher_role
;
GRANT UPDATE (state, object_key, variants, error_code, updated_at) ON attachments TO worker_role
;
GRANT UPDATE (state, error_code, updated_at) ON attachments TO dispatcher_role
;
GRANT UPDATE (state, attempt, lease_token, lease_until, next_attempt_at, published_at, error_code, updated_at)
ON attachment_jobs TO worker_role, dispatcher_role
;
REVOKE ALL ON schema_migrations FROM api_role
;
GRANT SELECT ON schema_migrations TO api_role
;