knobit.org

Recognises row security on an updatable column

edu:Knobit

https://knobit.org/id/knobit/S-305

Also as Turtle · JSON-LD · RDF/XML · AI benchmark on Skilirium

Context functionsResult evaluation
Knobit creation methodsAI generated
Knobit typesSkill
LCG purposesAssessing the learner's knowledge or skill state
LCG purposesSelecting an assessment task or learning activity
action verbRecognises en
applies knowledgeExplains row-level security
assessment criterionFlags 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 en
assessment methodskill-tests task: Bank role and entitlement design (dsec-access-control) en
conforms to profilehttps://oppekava.edu.ee/a/Knobitite_kirjeldamise_ja_seostamise_reeglid#LCG-KNOBIT-0.1
dcterms:identifierS-305
dcterms:licensehttps://creativecommons.org/licenses/by/4.0/
dcterms:sourceReview checklist 03-access-control, row 5 (27002 8.3) en
expected resultThe filter and an attribute the user cannot change en
owl:sameAshttps://bitbucket.org/reffa/ontology/id/knobit/data-security/03-access-control/05
rdfs:labelRecognises row security on an updatable column en
schema:creativeWorkStatusaccepted
schema:isPartOfData security and privacy (DAMA-DMBOK2)
skos:altLabelRow security on an updatable column en
skos:definitionThe row filter reads a column the restricted user can change. en
skos:prefLabelRecognises row security on an updatable column en
target objectrow filter on a column the restricted user can change en

Used by

includes knobitDesigns access by need, with duties segregated and masking that holds
requires knobitDesign access control