The Duty Status display is secured by which mechanism?

• A. Role-based access control
• B. Row-level security using UICs
• C. Time-based access
• D. Location-based access

Answer: (B)

Row-level security using UICs is used to show the Duty Status display only to the data that belongs to a user’s unit. The UIC identifies the user’s unit, and the data table includes a UIC for each row. A row-level security policy ties the user’s UIC to the rows, so queries automatically return only records whose UIC matches the user’s. This ensures unit-specific visibility and prevents cross-unit data from appearing in the display, even if the user has access to the screen.

Role-based access control would determine what actions a user can perform, not which specific rows they can see. Time-based access restricts access by time window, not by data ownership. Location-based access restricts by physical location, not by unit affiliation of the data.