Recognises masking a join can undo

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

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

Context functions	Result evaluation
Knobit creation methods	AI generated
Knobit types	Skill
LCG purposes	Assessing the learner's knowledge or skill state
LCG purposes	Selecting an assessment task or learning activity
action verb	Recognises en
applies knowledge	Explains how database tables and relationships are structured
applies knowledge	Explains data masking and its limits
assessment criterion	Flags the deficient case and passes the acceptable one. Deficient: MK-001 masks `customer_view.name`; the view exposes `personal_code`, which joins to `party` in clear Acceptable: Key masked or tokenised in the view too en
assessment method	skill-tests task: Bank role and entitlement design (dsec-access-control) en
conforms to profile	https://oppekava.edu.ee/a/Knobitite_kirjeldamise_ja_seostamise_reeglid#LCG-KNOBIT-0.1
dcterms:identifier	S-304
dcterms:license	https://creativecommons.org/licenses/by/4.0/
dcterms:source	Review checklist 03-access-control, row 4 (27002 8.11) en
expected result	The masked column, the key and the clear table it reaches en
followed by	Closes the clear-text paths around a masked column
owl:sameAs	https://bitbucket.org/reffa/ontology/id/knobit/data-security/03-access-control/04
rdfs:label	Recognises masking a join can undo en
schema:creativeWorkStatus	accepted
schema:isPartOf	Data security and privacy (DAMA-DMBOK2)
skos:altLabel	Masking a join can undo en
skos:definition	A masked column next to an unmasked key that joins to the unmasked source. en
skos:prefLabel	Recognises masking a join can undo en
target object	masked column next to an unmasked key joining to clear data en

Used by

includes knobit	Designs access by need, with duties segregated and masking that holds
requires knobit	Design access control