Skilirium

Recognises row security on an updatable column

S-305 · Skill knobit · Activity: Design access control · Competence: Data security

The row filter reads a column the restricted user can change.

Can AI do this?

Not settled yet The benchmark tested this, but the models' answers do not settle yet whether they master it. 0 of 4 models in the current benchmark master it.

ModelTierProbability of masteryStatus
gemini-4-argonFlagship 57%Not shown
gemini-3.5-flash-liteLow cost 54%Not shown
gpt-6-lunaLow cost 57%Not shown
claude-haiku-5-5Low cost 58%Not shown

Mastered means a probability of at least 90% that the model has this knobit, estimated from its graded answers. “Not shown” means the answers do not settle it either way. How the models are tested.

What it looks like in practice

Expected result: The filter and an attribute the user cannot change

How it is assessed: Flags the deficient case and passes the acceptable one. Deficient: RS-001 teller sees rows where account.branch_code = user.branch; tellers can update account.branch_code Acceptable: Branch from the HR directory; branch_code read-only to tellers

Also known as: Row security on an updatable column

Related knobits

Builds on

All 20 knobits of Design access control.

Source: Review checklist 03-access-control, row 5 (27002 8.3)