Reports2017-11-18T12:27:27+00:00

DIS Access Privileges

Description
Categories: Application, Enginatics
Discoverer access privileges

select
xxen_util.disco_user_type(eap.ap_eu_id,'&eul') user_type,
xxen_util.disco_user_name(eap.ap_eu_id,'&eul') user_name,
decode(eap.ap_type,'GBA','Business Area','GD','Workbook','GP','Privilege',eap.ap_type) access_type,
decode(eap.ap_type,'GBA',eb.ba_name,'GD',ed.doc_name,'GP',
decode(eap.gp_app_id,
1000,'Desktop and Plus Privilege',
1001,'Create/Edit Query',
1002,'Item Drill',
1003,'Drill Out',
1004,'Grant Workbook',
1005,'Collect Query Statistics',
1006,'Administration Privilege',
1007,'Set Privilege',
1008,'Create/Edit Business Area',
1009,'Format Business Area',
1010,'Create/Edit Summaries',
1012,'Schedule Workbooks',
1014,'Save Workbooks to Database',
1015,'Manage Scheduled Workbooks',
1024,'Create link',
eap.gp_app_id
)
,eap.ap_type) name,
xxen_util.meaning(decode(eap.ap_priv_level,1,'Y'),'YES_NO',0) allow_administration,
xxen_util.disco_user_name(eap.ap_created_by) created_by,
eap.ap_created_date creation_date,
xxen_util.disco_user_name(eap.ap_updated_by) last_updated_by,
eap.ap_updated_date last_update_date
from
&eul.eul5_access_privs eap,
&eul.eul5_bas eb,
&eul.eul5_documents ed
where
1=1 and
not (eap.ap_type='GP' and eap.gp_app_id in (1013,1018)) and
eap.gba_ba_id=eb.ba_id(+) and
eap.gd_doc_id=ed.doc_id(+)

Parameter Name SQL text Validation
End User Layer
<parameter_value>
LOV