business logic query UserRoleByRoleId

Parameters

iiRoleId

integer

each UsrRole where

UsrRole.Role_ID = iiRoleId

first Usr (inner-join) where

Usr.Usr_ID = UsrRole.Usr_ID AND

field name	data type	db field	description
tiRole_ID	integer	UsrRole.Role_ID	Role
tiUsr_ID	integer	UsrRole.Usr_ID	User
tcUsrLogin	character	Usr.UsrLogin	Login
tcUsrName	character	Usr.UsrName	User Name
tlUsrRoleIsDefaultRole	logical	UsrRole.UsrRoleIsDefaultRole	Indicates the default role per user.

BLF