Help needed: generate list of Users and their User Groups

[Keld Mollnitz]

Dear Community,

Can some one help create a query for Oracle which generates a list of all active users and their respective assigned User Group. Have in mind that a user can exist in multiple Clients and multiple User Groups..

Help would be much apreciated :-)

/Keld.

[Bernhard Flegel]

Hello Keld,

maybe the following sql-query can do the work for you.

Bye Bernhard

select a.OH_Client as "Client", a.OH_NAME as "User Name", USR_FIRSTNAME, USR_LASTNAME, USR_EMAIL1,b.OH_Name as "USRG Name" from OH a, oh b, USRG, USR
where a.OH_IDNR = USR_OH_IDNR
and a.OH_CLIENT not in (0)
and b.OH_CLIENT not in (0)
and a.OH_IDNR = USRG_USR_Idnr
and b.OH_Idnr = USRG_USG_Idnr
order by 2,4
;

[Keld Mollnitz]

Hi @Bernhard Flegel,

thanx mate..

/Keld.