Using the ROLES system table, you can determine the following database information, among other things:
·
All roles that
require a password to be specified before they can be activated
SELECT owner,
role
FROM DOMAIN.ROLES
WHERE password_required = 'YES'
·
All
roles that the current user uses as a default value
SELECT role
FROM DOMAIN.ROLES
WHERE defaultrole = 'YES'
All roles that are active in the current database session: see SESSION_ROLES
Role privilege: see ROLEPRIVILEGES