What happens when a user is in two roles?

[Anonymous]

If I set up RLS, using USERNAME() to give access based on the user accessing...

What happens whenever that user is added in two different roles, does it get randomly assigned to one, or can it have both access at the same time? (don't think this is possible, because the 2 access could conflict with each other...)

[SivaMani · Accepted solution]

@Anonymous, In that case, You will get the result like Result of Role 1 (let's say 2 records) and Result of Role 2 (let's say 6 records).