Skip to main content

Privacera Documentation

GET_UR_NAMES_Q()

Description: returns the list of user roles (with each role name in quotes, separated by comma) to which the querying user is a member. Can be used for comparison of character values.

Example:

  • The user is a member of rolesadmin andmanager,GET_UR_NAMES_Q() will return‘admin’,‘manager’.

Usage: can be used in:

  • Row Level Filter Policies - row level filters expressions

  • Example:emp_roles in (${{GET_UR_NAMES_Q()}})

  • Masking policy - Custom masking condition

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

  • Policy condition

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