問題文
Inspections must be visible to the whole maintenance division, while each technician's personal phone number on the technician table must be readable only by human resources. Which combination fits?
選択肢
- Giving the division the system administrator role, plus a business rule that hides the phone number.
- Sharing each inspection row with the division, plus column-level security on the phone number column with a column security profile granted to human resources, because sharing reaches everyone who needs the inspection without changing the security roles.
- Making the inspection table organization owned, plus a rollup column that counts phone numbers.
- An owning team holding a security role with business unit level read on inspections, plus column-level security on the phone number column with a column security profile granted to human resources.