Cyril_Delplanque_2297

Audit - Benutzeranforderung

Discussion created by Cyril_Delplanque_2297 on May 3, 2017
Latest reply on May 30, 2017 by Wolfgang_Brueckler_1288
Hallo,

Im Falle eines Audits könnten diese Anträge sinnvoll sein.

  •      Konto idle
select USR_FIRSTNAME, USR_LASTNAME
from USR
where USR_ACTIVE=0;

select Oh_client "client", Oh_name "object name", Usr_firstname "First name", Usr_lastname "Surname", Usr_lastsession "Last Login", Oh_crdate "Creation date"
from usr,Oh
where oh_idnr = usr_oh_idnr
and OH_DELETEFLAG = 0
and OH_IDNR > 100000
order by usr_lastsession ASC;

select oh1.oh_name as 'user',oh2.oh_name as 'group'
from oh as oh1,oh as oh2, usr, usrg, USG
where oh1.oh_idnr=USR_OH_Idnr
and oh2.oh_idnr=USG_OH_Idnr
and USRG_USR_Idnr=USR_OH_Idnr
and usrg_usg_idnr=usg_oh_idnr
and oh1.OH_DELETEFLAG = 0
and oh1.OH_IDNR > 100000;

Cyril

Outcomes