Assign a user to a data access policy

Assign users to a data access policy to give them permission to see the specified PII for the specified subjects or patients. You can assign either Oracle WebLogic Server user accounts or database user accounts, one account at a time.

1. On the database server, log in to SQL*Plus as CDM.
2. Run VPD_UTIL.ADD_CONFIG_USER, entering values as follows:
   • The data access policy name.
   • The user's user name.
   • (Optional) An expiration date for the user assignment in the format YYYY-MM-DD. On this date the user will be automatically deassigned and will no longer be able to access subject/patient data through the data access policy.

   For example:

   BEGIN
   VPD_UTIL.ADD_CONFIG_USER
      (I_EXISTING_CONFIG_NAME  =>	'PATIENT_GROUP_1_ALL_ATTRIBUTES' ,
      I_USER_NAME  => 'TESTER' ,
      I_EXPIRATION_DATE       => DATE '2025-12-31'   );
    END;/