mpe_accesscheck.sas File Reference

Checks group access level for a table or library. More...

Go to the source code of this file.

Detailed Description

In order for a user to be able to EDIT or APPROVE a table they must be in a group that has been granted access to that table in the MPE_SECURITY table. Alternatively, they may be in the &mpeadmins group (which has full access to everything).

Parameters

[in]	base_table	The base table to check for
[in]	user=	The user for which the access level should be returned. If not provided, the mf_user() result is used instead.
[in]	access_level=	(APPROVE) access_level (per MPE_SECURITY) reqd. Valid values: EDIT APPROVE VIEW
[in]	cntl_lib_var=	(MPELIB) The name of a global macro variable that contains the libref in which the MPE_SECURITY table is stored
[out]	outds=	(MED_ACCESSCHECK) Output WORK table containing all the groups for which the user is granted the particular ACCESS_LEVEL.

SAS Macros

• mp_abort.sas
• mf_getuniquename.sas
• mf_getuser.sas
• mf_verifymacvars.sas
• mpe_getgroups.sas

Related Macros

• mpe_accesscheck.test.sas

Version

9.2

Author

4GL Apps Ltd

Copyright

4GL Apps Ltd. This code may only be used within Data Controller and may not be re-distributed or re-sold without the express permission of 4GL Apps Ltd.

Definition in file mpe_accesscheck.sas.