Members of a functional role

Overview

This command will list the users who are associated with a certain functional role..

Related tables

Table	Description	Primary key (PK)	Connection tables
ADUSERROLE	Stores the relationship between functional role and users	CDROLE CDUSER	ADALLUSERS ADROLE
ADROLE	Stores functional roles	CDROLE	GNMAPPING GNPERMISSION
ADALLUSERS	Stores uses	CDUSER	ADALLUSERS ADUSEREXTERNALDATA GNFAVORITE

Oracle/Postgres/SQL Server

SELECT
ADU.NMUSER
FROM ADUSERROLE ADUR
INNER JOIN ADROLE ADR ON (ADUR.CDROLE = ADR.CDROLE)
INNER JOIN ADALLUSERS ADU ON (ADUR.CDUSER = ADU.CDUSER)
WHERE ADR.IDROLE = 'IDENTIFICADOR_DO_PAPEL_FUNCIONAL'; /* OBS 1 */

Notes

▪NOTE1: ID # of the functional role to be filtered in the search.

administration-05

Fields used on the view screen

#	Field ID	Type	Description
1	NMUSER	VARCHAR (255)	User name