An MDM administrator needs to configure access for a new data steward. The steward must be able to view, create, and update 'Customer' records but must be explicitly prevented from merging them. Additionally, the steward must have no access to 'Product' records. Which of the following is the most effective and secure method to achieve this?
-
A
Assign the user to the default 'Data Steward' role and then create a database trigger to block merge operations for that user.
-
B
Create a new role, grant it Read, Create, and Update privileges for the 'Customer' Base Object resource, withhold the Merge privilege, and ensure no privileges are granted for the 'Product' resource. Assign the user to this new role.
-
C
Configure two roles: one with full access to 'Customer' and another with no access to 'Product', and assign both roles to the user.
-
D
Grant the user direct SELECT, INSERT, and UPDATE permissions on the C_CUSTOMER base object table in the database.