Skip to main content

Privacera Documentation

GET_UG_ATTR_NAMES_Q()

Description: returns the list of attributes mapped to user groups (with each attribute name in single quotes) to which the querying user is a member. Can be used for comparison of character values.

Example:

  • The user joe is a member of the groupsadmin(attribute: access=auditor) andmanager (attribute: location=NY, access=admin).

  • GET_UG_ATTR_NAMES_Q() will return‘access’,‘location’.

Usage: can be used in:

  • Row Level Filter Policies - row level filters expressions

  • Example:data_module in (${{GET_UG_ATTR_NAMES_Q()}})

  • Masking policy - Custom masking condition

  • Example:CASE WHEN data_module in (${{GET_UG_ATTR_NAMES_Q()}}) THEN {col} ELSE 'NONE' END

  • Policy conditions

  • Example:GET_UG_ATTR_NAMES_Q()=='\’location\''