View input and acceptance criteria
Input
Forty named observations across four unchanged upstream SQL blocks and independent synthetic controls in disposable PostgreSQL 17.11. Separate ordinary writer, reader, table owner and unprivileged connections distinguish GRANTs, RLS filtering, implicit write checks, SQLSTATE errors, zero-row updates, owner/superuser bypass, permissive policy widening and transaction-local context. Caller-modifiable session claims are not authentication. Index setup is verified, not a performance benchmark. No hosted Supabase, auth.uid(), private SECURITY DEFINER helper, real identity, pool reuse, concurrency, production authorization, paid API or complete AI-client skill execution.
Acceptance criteria
Forty named observations pass in the recorded disposable fixture. Caller-modifiable identity and bypass counterexamples remain explicit; no full-skill, real identity or production security claim.
Recorded outcome
Forty named observations across four unchanged upstream SQL blocks and independent synthetic controls in disposable PostgreSQL 17.11. Separate ordinary writer, reader, table owner and unprivileged connections distinguish GRANTs, RLS filtering, implicit write checks, SQLSTATE errors, zero-row updates, owner/superuser bypass, permissive policy widening and transaction-local context. Caller-modifiable session claims are not authentication. Index setup is verified, not a performance benchmark. No hosted Supabase, auth.uid(), private SECURITY DEFINER helper, real identity, pool reuse, concurrency, production authorization, paid API or complete AI-client skill execution.
Recorded fixture evidence:
{
"executed_at": "2026-10-07T10:28:40.654988+00:00",
"python": "3.13.16",
"psycopg": "3.2.10",
"postgresql_version": "17.11",
"source_commit": "c9be0e931b7930f7d02126d04774d904c381e7d7",
"original_files_verified": 37,
"observations": 40,
"cases": [
{
"name": "writer_has_no_elevated_role_attributes",
"status": "passed",
"detail": null
},
{
"name": "reader_has_no_elevated_role_attributes",
"status": "passed",
"detail": null
},
{
"name": "owner_has_no_elevated_role_attributes",
"status": "passed",
"detail": null
},
{
"name": "unprivileged_has_no_elevated_role_attributes",
"status": "passed",
"detail": null
},
{
"name": "native_writer_inherits_only_declared_order_privileges",
"status": "passed",
"detail": [
true,
true,
true,
false,
false
]
},
{
"name": "native_reader_can_select_declared_product_table",
"status": "passed",
"detail": null
},
{
"name": "native_reader_cannot_select_ungranted_orders",
"status": "passed",
"detail": {
"sqlstate": "42501"
}
},
{
"name": "ordinary_writer_sees_all_rows_before_RLS",
"status": "passed",
"detail": null
},
{
"name": "native_RLS_block_filters_ordinary_owner",
"status": "passed",
"detail": null
},
{
"name": "native_policy_enabled_forced_all_and_implicit_check",
"status": "passed",
"detail": [
true,
true,
"*",
true,
true,
true
]
},
{
"name": "ordinary_writer_sees_own_rows",
"status": "passed",
"detail": null
},
{
"name": "caller_can_change_session_claim_to_other_identity",
"status": "passed",
"detail": null
},
{
"name": "superuser_bypasses_even_forced_RLS",
"status": "passed",
"detail": null
},
{
"name": "missing_session_context_reports_error",
"status": "passed",
"detail": {
"sqlstate": "42704"
}
},
{
"name": "invalid_session_context_reports_cast_error",
"status": "passed",
"detail": {
"sqlstate": "22P02"
}
},
{
"name": "granted_reader_is_filtered_by_RLS",
"status": "passed",
"detail": null
},
{
"name": "reader_insert_denied_by_table_privilege",
"status": "passed",
"detail": {
"sqlstate": "42501"
}
},
{
"name": "policy_does_not_grant_table_access",
"status": "passed",
"detail": {
"sqlstate": "42501"
}
},
{
"name": "native_all_policy_allows_matching_insert",
"status": "passed",
"detail": null
},
{
"name": "implicit_with_check_rejects_other_identity_insert",
"status": "passed",
"detail": {
"sqlstate": "42501"
}
},
{
"name": "implicit_with_check_rejects_ownership_change",
"status": "passed",
"detail": {
"sqlstate": "42501"
}
},
{
"name": "rejected_ownership_change_leaves_row_unchanged",
"status": "passed",
"detail": null
},
{
"name": "other_identity_update_affects_zero_rows",
"status": "passed",
"detail": null
},
{
"name": "other_identity_row_remains_unchanged",
"status": "passed",
"detail": null
},
{
"name": "matching_update_succeeds",
"status": "passed",
"detail": null
},
{
"name": "writer_delete_denied_by_table_privilege",
"status": "passed",
"detail": {
"sqlstate": "42501"
}
},
{
"name": "writer_truncate_denied_by_table_privilege",
"status": "passed",
"detail": {
"sqlstate": "42501"
}
},
{
"name": "table_owner_without_schema_create_cannot_create_index",
"status": "passed",
"detail": {
"sqlstate": "42501"
}
},
{
"name": "native_RLS_column_index_created",
"status": "passed",
"detail": "CREATE INDEX orders_user_id_idx ON public.orders USING btree (user_id)"
},
{
"name": "ordinary_table_owner_bypasses_without_force",
"status": "passed",
"detail": null
},
{
"name": "force_restores_owner_filtering",
"status": "passed",
"detail": null
},
{
"name": "permissive_extra_policy_widens_select",
"status": "passed",
"detail": null
},
{
"name": "removing_extra_policy_restores_select_filter",
"status": "passed",
"detail": null
},
{
"name": "transaction_local_context_selects_other_identity",
"status": "passed",
"detail": null
},
{
"name": "transaction_local_context_restores_session_value",
"status": "passed",
"detail": null
},
{
"name": "enabled_RLS_without_policy_hides_rows",
"status": "passed",
"detail": null
},
{
"name": "enabled_RLS_without_policy_rejects_insert",
"status": "passed",
"detail": {
"sqlstate": "42501"
}
},
{
"name": "row_security_off_does_not_bypass_policy",
"status": "passed",
"detail": {
"sqlstate": "42501"
}
},
{
"name": "restored_row_security_keeps_matching_rows",
"status": "passed",
"detail": null
},
{
"name": "fixture_retains_other_identity_and_no_failed_inserts",
"status": "passed",
"detail": null
}
],
"native_SQL_blocks_executed": 4,
"executed_blocks": [
{
"source": "references/security-privileges.md",
"block_index": 1,
"block_sha256": "96ac0ee0f45b65d60ba4516f7071190df95124bc3661c3fc682a80aaa52225c3",
"source_rewritten": false
},
{
"source": "references/security-privileges.md",
"block_index": 2,
"block_sha256": "199ad4c20d41db0ff8be9799da80fa6bfda6ace4f96d0b98e9a83178a72f109b",
"source_rewritten": false
},
{
"source": "references/security-rls-basics.md",
"block_index": 1,
"block_sha256": "7ace28d7ee4101a5888b5ff0086edc733032f20f940237d097fb6b519c3c113e",
"source_rewritten": false
},
{
"source": "references/security-rls-performance.md",
"block_index": 3,
"block_sha256": "487dc32b09c68e24f7d184fc763b1f73a085a2ff0009a6e20f27675d4b7d9629",
"source_rewritten": false
}
],
"role_attributes": {
"writer": [
false,
false,
false,
false,
false
],
"reader": [
false,
false,
false,
false,
false
],
"owner": [
false,
false,
false,
false,
false
],
"unprivileged": [
false,
false,
false,
false,
false
]
},
"source_hashes": {
"references/security-privileges.md": "095909274a4fb43df785d7144cf674eeb40284d2d45628f14af4108737b93663",
"references/security-rls-basics.md": "e04dd1a3a382aafdaaa73fe9f7976352acdde6e90c2a2470d281b94d4f44b096",
"references/security-rls-performance.md": "2e1faeca7d5746e246b1c78f9492fe2a9cfa41c4d7fa1e23c402d58fa18ea014"
},
"runner_sha256": "5787a86e5c1f10dcf19cfa54c91541df9e8c7e44ad20625d8484ac7a3b450c41",
"server_image_id": "sha256:b0f9560a2de083e2cc7382e75f808c7381a32852a7ec49117deedb300e552b24",
"client_image_id": "sha256:5291689d3752b989c53242046453362888b9e371c1dac4491eb00729f6bad6f9",
"runtime_tested": false,
"ai_client_executed": false,
"production_tested": false,
"hosted_supabase_used": false,
"real_identity_verified": false,
"paid_API_used": false,
"performance_speedup_measured": false,
"external_network_access": false,
"synthetic_data_only": true,
"scope": "Four unchanged upstream SQL blocks plus independent role/claim/error controls in an empty PostgreSQL 17 fixture. Ordinary roles connect separately; bootstrap superuser is only setup and explicit bypass control. Session variables are deliberately caller-modifiable and are not authentication. No auth.uid(), hosted Supabase, private SECURITY DEFINER helper, concurrency, production authorization or full AI-client execution."
}Environment
Linux Docker internal network, no host ports/external access; PostgreSQL 17.11, Python 3.13.16, psycopg 3.2.10; disposable tmpfs database and synthetic roles/orders. Server 1 CPU/512 MiB, client 1 CPU/256 MiB; no production volumes or credentials.
Package SHA-256: 09e7272645b0adb69e18d05b2ff72ec9f4bb0ed69e06a3512c3393522fc9c0f8
Outcome recorded: 2026-10-07 10:28 UTC
Open evidence ↗