Overview
This command will list the functional roles with which a certain user is associated.
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
ADR.NMROLE
FROM ADUSERROLE ADUR
INNER JOIN ADROLE ADR ON (ADUR.CDROLE = ADR.CDROLE)
INNER JOIN ADALLUSERS ADU ON (ADUR.CDUSER = ADU.CDUSER)
WHERE ADU.IDUSER = 'MATRICULA_DO_USUARIO'; /* OBS 1 */
|
Notes
NOTE1: User ID to be filtered in the search.
Fields used on the view screen
#
|
Field ID
|
Type
|
Description
|
1
|
NMROLE
|
VARCHAR (255)
|
Functional role name
|
|