$PBExportHeader$d_pfcsecurity_report_by_user.srd $PBExportComments$PFC Security user report release 6; datawindow(units=0 timer_interval=0 color=16777215 processing=0 print.documentname="" print.orientation = 0 print.margin.left = 110 print.margin.right = 110 print.margin.top = 97 print.margin.bottom = 97 print.paper.source = 0 print.paper.size = 0 print.prompt=no print.buttons=no print.preview.buttons=no ) header(height=192 color="536870912" ) summary(height=0 color="536870912" ) footer(height=96 color="536870912" ) detail(height=60 color="536870912" height.autosize=yes) table(column=(type=char(16) updatewhereclause=yes name=user_group_name dbname="security_info.user_name" ) column=(type=char(32) updatewhereclause=yes name=security_users_description dbname="security_users.description" ) column=(type=char(32) updatewhereclause=yes name=security_apps_application dbname="security_apps.application" ) column=(type=char(64) updatewhereclause=yes name=security_apps_description dbname="security_apps.description" ) column=(type=char(64) updatewhereclause=yes name=security_info_window dbname="security_info.window" ) column=(type=char(64) updatewhereclause=yes name=security_info_control dbname="security_info.control" ) column=(type=char(254) updatewhereclause=yes name=security_template_description dbname="security_template.description" ) column=(type=char(24) updatewhereclause=yes name=object_type dbname="security_template.object_type" ) column=(type=char(1) updatewhereclause=yes name=status dbname="security_info.status" values="Invisible I/Enabled E/Disabled D/Not Set N/" ) column=(type=long updatewhereclause=yes name=priority dbname="security_users.priority" ) column=(type=long updatewhereclause=yes name=user_type dbname="security_users.user_type" initial="0" values="User 0/Group 1/" ) retrieve=" SELECT security_info.user_name, security_users.description, security_apps.application, security_apps.description, security_info.window, security_info.control, security_template.description, security_template.object_type, security_info.status, security_users.priority, security_users.user_type FROM security_apps, security_info, security_template, security_users WHERE ( security_apps.application = security_info.application ) and ( security_info.application = security_template.application ) and ( security_info.window = security_template.window ) and ( security_info.control = security_template.control ) and ( security_info.user_name = security_users.name ) and ( ( security_info.user_name = :username ) ) UNION SELECT security_info.user_name, security_users.description, security_apps.application, security_apps.description, security_info.window, security_info.control, security_template.description, security_template.object_type, security_info.status, security_users.priority, security_users.user_type FROM security_apps, security_groupings, security_info, security_template, security_users WHERE ( security_info.application = security_template.application ) and ( security_info.window = security_template.window ) and ( security_info.control = security_template.control ) and ( security_info.application = security_apps.application ) and ( security_info.user_name = security_groupings.group_name ) and ( security_groupings.group_name = security_users.name ) and ( ( security_groupings.user_name = :username ) ) " arguments=(("username", string)) sort="security_apps_application A security_info_window A security_info_control A priority A " ) group(level=1 header.height=92 trailer.height=32 by=("security_apps_application" ) newpage=yes header.color="536870912" trailer.color="536870912" ) group(level=2 header.height=216 trailer.height=44 by=("security_info_window" ) header.color="536870912" trailer.color="536870912" ) text(band=header alignment="2" text="Description :"border="0" color="0" x="613" y="112" height="64" width="457" name=security_users_description_t font.face="MS Sans Serif" font.height="-10" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) report(band=header dataobject="d_pfcsecurity_display_user_info" x="1083" y="108" height="72" width="1993" border="0" height.autosize=yes criteria="" nest_arguments=(("username")) trail_footer = yes slideup=directlyabove ) text(band=header alignment="0" text="PFC Security Report for User ID : "border="0" color="0" x="5" y="24" height="72" width="1065" font.face="MS Sans Serif" font.height="-10" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" ) compute(band=header alignment="1" expression="today()"border="0" color="0" x="3013" y="24" height="72" width="485" format="[general]" font.face="MS Sans Serif" font.height="-10" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) compute(band=header alignment="0" expression="username"border="0" color="0" x="1088" y="24" height="72" width="1175" format="[general]" font.face="MS Sans Serif" font.height="-10" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" ) column(band=header.1 id=3 alignment="0" tabsequence=32766 border="0" color="0" x="411" y="20" height="52" width="768" format="[general]" name=security_apps_application edit.limit=32000 edit.case=any edit.autoselect=yes edit.autohscroll=yes font.face="MS Sans Serif" font.height="-8" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) text(band=header.1 alignment="1" text="Description :"border="0" color="0" x="1189" y="20" height="52" width="389" name=security_apps_description_t font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) column(band=header.1 id=4 alignment="0" tabsequence=32766 border="0" color="0" x="1582" y="20" height="52" width="773" format="[general]" name=security_apps_description edit.limit=32000 edit.case=any edit.autoselect=yes edit.autohscroll=yes font.face="MS Sans Serif" font.height="-8" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) text(band=header.1 alignment="1" text="Application :"border="0" color="0" x="18" y="20" height="52" width="384" name=security_apps_application_t font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) line(band=header.1 x1="9" y1="84" x2="3497" y2="84" pen.style="0" pen.width="9" pen.color="0" background.mode="1" background.color="553648127" ) text(band=header.2 alignment="1" text="Object :"border="0" color="0" x="73" y="68" height="52" width="224" name=security_info_window_t font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) text(band=header.2 alignment="2" text="Priority"border="4" color="0" x="3301" y="144" height="52" width="192" name=priority_t font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) text(band=header.2 alignment="2" text="User Type"border="4" color="0" x="3095" y="92" height="104" width="187" name=user_type_t font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) text(band=header.2 alignment="0" text="Group/User"border="4" color="0" x="2702" y="144" height="52" width="375" font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) text(band=header.2 alignment="2" text="Control"border="4" color="0" x="18" y="144" height="52" width="1161" name=security_info_control_t font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) text(band=header.2 alignment="2" text="Description"border="4" color="0" x="1198" y="144" height="52" width="818" name=security_template_description_t font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) text(band=header.2 alignment="2" text="Status"border="4" color="0" x="2478" y="144" height="52" width="210" name=status_t font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) text(band=header.2 alignment="2" text="Object Type"border="4" color="0" x="2030" y="144" height="52" width="434" name=object_type_t font.face="MS Sans Serif" font.height="-8" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) column(band=header.2 id=5 alignment="0" tabsequence=32766 border="0" color="0" x="311" y="68" height="52" width="768" format="[general]" name=security_info_window edit.limit=32000 edit.case=any edit.autoselect=yes edit.autohscroll=yes font.face="MS Sans Serif" font.height="-8" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) column(band=detail id=10 alignment="2" tabsequence=32766 border="0" color="0" x="3305" y="4" height="56" width="192" format="[General]" name=priority edit.limit=0 edit.case=any edit.autoselect=yes edit.autohscroll=yes font.face="MS Sans Serif" font.height="-8" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) column(band=detail id=11 alignment="2" tabsequence=32766 border="0" color="0" x="3095" y="4" height="56" width="187" format="[General]" name=user_type edit.name="user_types" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.codetable=yes font.face="MS Sans Serif" font.height="-8" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) column(band=detail id=1 alignment="0" tabsequence=32766 border="0" color="0" x="2702" y="4" height="56" width="375" format="[general]" name=user_group_name edit.limit=0 edit.case=any edit.autoselect=yes font.face="MS Sans Serif" font.height="-8" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) column(band=detail id=6 alignment="0" tabsequence=32766 border="0" color="0" x="18" y="4" height="56" width="1161" format="[general]" name=security_info_control edit.limit=32000 edit.case=any edit.autoselect=yes edit.autohscroll=yes font.face="MS Sans Serif" font.height="-8" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) column(band=detail id=7 alignment="0" tabsequence=32766 border="0" color="0" x="1198" y="4" height="56" width="818" format="[general]" name=security_template_description edit.limit=32000 edit.case=any edit.autoselect=yes edit.autohscroll=yes font.face="MS Sans Serif" font.height="-8" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) column(band=detail id=9 alignment="0" tabsequence=32766 border="0" color="0" x="2478" y="4" height="56" width="210" format="[general]" name=status ddlb.limit=0 ddlb.allowedit=no ddlb.case=any font.face="MS Sans Serif" font.height="-8" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) column(band=detail id=8 alignment="0" tabsequence=32766 border="0" color="0" x="2030" y="4" height="56" width="434" format="[general]" name=object_type edit.limit=32000 edit.case=any edit.autoselect=yes edit.autohscroll=yes font.face="MS Sans Serif" font.height="-8" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) line(band=trailer.2 x1="5" y1="8" x2="3493" y2="8" pen.style="0" pen.width="9" pen.color="0" background.mode="1" background.color="553648127" ) line(band=trailer.1 x1="5" y1="8" x2="3493" y2="8" pen.style="0" pen.width="9" pen.color="0" background.mode="1" background.color="553648127" ) line(band=trailer.1 x1="5" y1="20" x2="3493" y2="20" pen.style="0" pen.width="9" pen.color="0" background.mode="1" background.color="553648127" ) compute(band=footer alignment="1" expression="'Page ' + page() + ' of ' + pageCount()"border="0" color="0" x="2830" y="16" height="72" width="667" format="[general]" font.face="MS Sans Serif" font.height="-10" font.weight="700" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" ) sparse(names="security_info_control security_template_description object_type")htmltable(border="1" cellpadding="0" cellspacing="0" generatecss="no" nowrap="yes")
File: d_pfcsecurity_report_by_user.srd
Size: 13725
Date: Tue, 22 Jan 2008 23:33:49 +0100
Size: 13725
Date: Tue, 22 Jan 2008 23:33:49 +0100