# least-privilege: lab7: each service identity vs PostgreSQL grants, S3 prefixes, OpenBao policies, Redis ACL
# date: 2026-11-07 15:07:38, commit: 5bfc53a + uncommitted changes
# command: python student-tests/test_least_privilege.py
# exit code: 0, 2.7 s


api -> postgres
  PASS  SELECT users                               expect allowed  observed allowed
  PASS  INSERT outbox (enqueue)                    expect allowed  observed allowed
  PASS  UPDATE users.username                      expect denied   observed denied
  PASS  SELECT outbox                              expect denied   observed denied
  PASS  DELETE messages                            expect denied   observed denied
  PASS  DROP TABLE messages                        expect denied   observed denied
  PASS  CREATE TABLE                               expect denied   observed denied
  PASS  ALTER ROLE (escalate)                      expect denied   observed denied

api -> s3
  PASS  PUT staging/                               expect allowed  observed allowed
  PASS  DELETE staging/ (rollback)                 expect allowed  observed allowed
  PASS  PUT attachments/ (worker's prefix)         expect denied   observed denied
  PASS  GET staging/ (upload sources)              expect denied   observed denied
  PASS  LIST bucket                                expect denied   observed denied
  PASS  DELETE attachments/                        expect denied   observed denied
  PASS  CREATE bucket                              expect denied   observed denied

api -> openbao
  PASS  own secret keys (no admin credentials)     expect ok       observed ok
  PASS  read messenger/worker                      expect denied   observed denied
  PASS  read messenger/dispatcher                  expect denied   observed denied
  PASS  read messenger/janitor                     expect denied   observed denied
  PASS  read messenger/migrate                     expect denied   observed denied
  PASS  read messenger/s3-init                     expect denied   observed denied
  PASS  write own secret                           expect denied   observed denied
  PASS  write ACL policy                           expect denied   observed denied
  PASS  list auth methods                          expect denied   observed denied
  PASS  create token                               expect denied   observed denied

api -> redis
  PASS  GET session:*                              expect allowed  observed allowed
  PASS  GET other key                              expect denied   observed denied
  PASS  KEYS *                                     expect denied   observed denied
  PASS  FLUSHALL                                   expect denied   observed denied
  PASS  CONFIG GET                                 expect denied   observed denied
  PASS  ACL LIST                                   expect denied   observed denied
  PASS  SUBSCRIBE / PUBLISH                        expect denied   observed denied

worker -> postgres
  PASS  SELECT attachments                         expect allowed  observed allowed
  PASS  SELECT users (passwords)                   expect denied   observed denied
  PASS  SELECT messages                            expect denied   observed denied
  PASS  DELETE attachments                         expect denied   observed denied
  PASS  UPDATE outbox                              expect denied   observed denied

worker -> s3
  PASS  PUT attachments/                           expect allowed  observed allowed
  PASS  LIST attachments/                          expect allowed  observed allowed
  PASS  LIST bucket root                           expect denied   observed denied
  PASS  PUT outside known prefixes                 expect denied   observed denied
  PASS  CREATE bucket                              expect denied   observed denied

worker -> openbao
  PASS  own secret keys (no admin credentials)     expect ok       observed ok
  PASS  read messenger/api                         expect denied   observed denied
  PASS  read messenger/dispatcher                  expect denied   observed denied
  PASS  read messenger/janitor                     expect denied   observed denied
  PASS  read messenger/migrate                     expect denied   observed denied
  PASS  read messenger/s3-init                     expect denied   observed denied
  PASS  write own secret                           expect denied   observed denied
  PASS  write ACL policy                           expect denied   observed denied
  PASS  list auth methods                          expect denied   observed denied
  PASS  create token                               expect denied   observed denied

dispatcher -> postgres
  PASS  SELECT outbox                              expect allowed  observed allowed
  PASS  SELECT users                               expect denied   observed denied
  PASS  SELECT messages                            expect denied   observed denied
  PASS  DELETE attachments                         expect denied   observed denied

dispatcher -> openbao
  PASS  own secret keys (no admin credentials)     expect ok       observed ok
  PASS  read messenger/api                         expect denied   observed denied
  PASS  read messenger/worker                      expect denied   observed denied
  PASS  read messenger/janitor                     expect denied   observed denied
  PASS  read messenger/migrate                     expect denied   observed denied
  PASS  read messenger/s3-init                     expect denied   observed denied
  PASS  write own secret                           expect denied   observed denied
  PASS  write ACL policy                           expect denied   observed denied
  PASS  list auth methods                          expect denied   observed denied
  PASS  create token                               expect denied   observed denied

janitor -> postgres
  PASS  SELECT attachments                         expect allowed  observed allowed
  PASS  SELECT users                               expect denied   observed denied
  PASS  INSERT messages                            expect denied   observed denied
  PASS  DELETE chats                               expect denied   observed denied

janitor -> s3
  PASS  LIST bucket                                expect allowed  observed allowed
  PASS  GET object content                         expect denied   observed denied
  PASS  CREATE bucket                              expect denied   observed denied

janitor -> openbao
  PASS  own secret keys (no admin credentials)     expect ok       observed ok
  PASS  read messenger/api                         expect denied   observed denied
  PASS  read messenger/worker                      expect denied   observed denied
  PASS  read messenger/dispatcher                  expect denied   observed denied
  PASS  read messenger/migrate                     expect denied   observed denied
  PASS  read messenger/s3-init                     expect denied   observed denied
  PASS  write own secret                           expect denied   observed denied
  PASS  write ACL policy                           expect denied   observed denied
  PASS  list auth methods                          expect denied   observed denied
  PASS  create token                               expect denied   observed denied

83 checks, 0 failed; saved to evidence/least-privilege.json
PASS: every service identity can do its job and nothing else that was probed
