Grant access to all subject and patient data

A global data access policy permits access to all patients and subjects and all their PII attribute values. Users who are assigned to this data access policy do not need to be assigned to any other data access policy, even if row filtering is on. Its ID value is 1.

1. On the database server, log in to SQL*Plus as CDM.
2. Run stored procedure VPD_UTILADD_CONFIG_USER entering values as follows:
   • The configuration ID set to 1.
   • 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_ID  =>	1 ,
      I_USER_NAME  => 'JSMITH' ,
      I_EXPIRATION_DATE       => DATE '2025-12-31'   );
    END;
   /