ROLE SQL Function

Returns the role or roles that are active for the user currently logged in.

Syntax

ROLE()

If you are running with the ROLE_MERGE Rules Engine Parameter set to False, exactly 1 role is active. The name of this role is returned.

If you are running with the ROLE_MERGE Rules Engine Parameter set to True, at least 1 role is active. If 1 role is active, the name of this role is returned:

ROLE_1

If more than 1 role is active, the names of the active roles are shown in brackets and separated by commas:

[ROLE_1,ROLE_2]

Note

This is a convertible function resolved by USoft and thus supported on all RDBMS platforms.