Skip to main content

Privacera Documentation

GET_UG_ATTR_NAMES()

Description: returns the list of attributes keys mapped to the user groups to which the querying user is a member. Can be used for comparison of numeric values.

Example:

  • The user joe is a member of the groupadmin(attribute: 10=auditor).

  • GET_UG_ATTR_NAMES() will return10.

Usage: can be used in:

  • Row Level Filter Policies - row level filters expressions

  • Example:dept_id in (${{GET_UG_ATTR_NAMES()}})

  • Masking policy - Custom masking condition

  • Example:CASE WHEN dept_id in (${{GET_UG_ATTR_NAMES()}}) THEN {col} ELSE '0' END

  • Policy conditions:

  • Example: GET_UG_ATTR_NAMES()=='location'