Revoke specimen alias access for a user

Note:

To revoke specimen alias access from a user, use numeric identifiers (row_wids) of the specific study or patient group.

1. On the database server, log in to SQL*Plus as CDM.
2. Run stored procedure VPD_UTILrevoke_svcprv_user, entering values as follows:
   • The user's user name.
   • Service provider scope. Set one of the following parameters:
     • I_ISSNG_SVCPRV_ID. To revoke access from aliases used by a single service provider, enter the service provider's ID.
     • I_ANY_ISSNG_SVCPRVS. To revoke access from aliases created by any service provides, set this parameter s to 1.
   • Subject and/or patient scope. Set one of the following parameters, or set one study parameter and one patient group parameter:
     • I_STUDY_NAME. To revoke access from aliases used in a single study, enter the name of the study.
     • I_ANY_STUDY. To revoke access from aliases used in all studies, set this parameter to 1.
     • I_PT_GROUP_NAME. To revoke access from aliases used for a single patient group, enter the name of the patient group.
     • I_ANY_PT_GROUP. To revoke access from aliases used in all patient groups, set this parameter to 1.

       Note:

       For the purpose of revoking access, the parameters for any study, any pt group, and any provider do not include any separately granted named study, patient, or provider scope. You must revoke these separately if needed.

Example 1: Revoke access to one study/provider combination

Revoke access to study_wid=99 and Service Provider (row_wid=105) from user TSTUSER1.

begin
vpd_util.revoke_svcprv_user (
    i_user_name =>'TSTUSER1',
  i_study_wid =>99,
  i_issng_svcprv_wid =>105
) ;
end;
/

Example 2: Revoke access to one patient group/provider combination

Revoke access to patient_group_wid=10 and Service Provider (row_wid=105) from user TSTUSER2.

begin
vpd_util.revoke_svcprv_user (
    i_user_name =>'TSTUSER2',
i_pt_group_wid =>10,
  i_issng_svcprv_wid =>105
) ;
end;
/

Example 3: Revoke access to any study, patient group, and provider granted using parameter I_ANY_STUDY, I_ANY_PT_GROUP, and I_ANY_ISSNG_SVCPRVS

Revoke access from a user to any study or patient group or service provider that was granted through an “any" parameter.

begin
vpd_util.revoke_svcprv_user (
    i_user_name =>'TSTUSER3',
  i_any_study =>1,
  i_any_pt_group =>1,
  i_any_issng_svcprvs =>1
) ;
end;
/