mpe_columnlevelsecurity.sas File Reference

Filters a table with CLS rules. More...

Go to the source code of this file.

Detailed Description

Implements CLS as per the rules described here:

https://docs.datacontroller.io/column-level-security/

Usage:

%mpe_columnlevelsecurity(TGTLIB,TGTDS,work.inds
  ,mode=VIEW
  ,clsds=dc.mpe_cls
  ,groupds=work.groups
  ,outds=work.final
  ,outmeta=work.cls_rules
)

Parameters

[in]	tgtlib	The libref of the target table
[in]	tgtds	The dataset reference of the target table
[in]	inds	A two-level (lib.ds) reference to the WORK table to which to apply the column filter rules
[in]	mode=	(VIEW) Either VIEW or EDIT to indicate whether the resulting table is intended to be viewable or editable.
[in]	groupds=	(work.groups)A two-level (lib.ds) reference to a dataset containing the list of groups of which the current user is a member. The column containing the group name should be called groupname.
[in]	clsds=	(work.clsds) A two-level (lib.ds) reference to the configuration table containing the CLS rules to apply.
[out]	outds=	(WORK.CLSVIEW) A two-level (lib.ds) reference to the WORK dataset to create
[out]	outmeta=	(WORK.CLS_RULES)The rule metadata, with the following structure: |CLS_VARIABLE_NM:$32.|CLS_HIDE:best.| |—|—|—|—|—| |SOME_VARIABLE|0| |VAR3|1|

SAS Macros

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_columnlevelsecurity.sas.