Skip to main content

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?

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