Skip to main content

Privacera Documentation

With default Value - GET_UG_NAMES_Q(‘default_value’)

Description: returns the list of user groups (with each group name in quotes) to which the querying user is a member. If the user is not a member of any group, ‘default_value’ will be returned. Can be used for comparison of character values.

Example:

  • The user is a member of groups admin and manager,GET_UR_NAMES_Q(‘executive’) will return‘admin’,‘manager’.

  • The user is not a member of any role,GET_UR_NAMES_Q(‘executive’) will return‘executive’.

Usage: can be used in:

  • Row Level Filter Policies - row level filters expressions

  • Example:location in (${{GET_UR_NAMES_Q(‘executive’)}})

  • Masking policy - Custom masking condition

  • Example:CASE WHEN location in (${{GET_UR_NAMES_Q(‘executive’)}}) THEN {col} ELSE 'NONE' END

  • Policy condition

  • Example:GET_UR_NAMES_Q(‘operator’)==’\’admin\’’