Skip to main content

Privacera Documentation

With default Value - GET_UR_NAMES(‘default_value’)

Description: returns the list of user roles (without quotes, separated by comma) to which the querying user is a member. If the user is not a member of any role, ‘default_value’ will be returned. Can be used for comparison of numeric or character values.

Example:

  • The user is a member of rolesadmin andmanager,GET_UR_NAMES(‘none’) will returnadmin,manager.

  • The user is not a member of any role,GET_UR_NAMES(‘none’) will returnnone.

Usage: can be used in:

  • Row Level Filter Policies - row level filters expressions

  • Example:dept_id in (${{GET_UR_NAMES(‘20’)}})

  • Example:location=’${{GET_UR_NAMES(‘NY’)}}’

  • Masking policy - Custom masking condition

  • Example:CASE WHEN dept_id in (${{GET_UR_NAMES(‘20’)}}) THEN {col} ELSE '0' END

  • Policy condition

  • Example:GET_UR_NAMES(‘operator’)==’admin’