Solved

Role Select Restricting Condition not applied in a Job

  • 30 September 2022
  • 1 reply
  • 27 views

Badge

I have a implemented a Role Select Restricting Condition on a table which limits the records that are returned when performing a select on that table.

This works fine but when I execute a Job that executes a select on that table the Resticting Condition is not applied and all table records are returned.

This seems like incorrect behaviour to me.

Is this by design?

icon

Best answer by dara.sami 30 September 2022, 11:03

View original

1 reply

Userlevel 2
Badge +1

Hi @kesselringj ,

I think this may be due to the scope of the condition, the select has only foreground scope. In this article they explain it more:

 

 

Scope of role conditions

A role condition can have either Foreground or Background scope, but this also depends on the Table Right it is attached to:

  • Role conditions attached to SELECT rights can only have Foreground scope.

More on scopes:

 

 

Reply