PBMiner Sources PFC11/security/pfcsecad/d_pfcsecurity_report_by

Sources
PFC11
security
pfcsecad
d_pfcsecurity_report_by_window.srd
File: d_pfcsecurity_report_by_window.srd
Size: 10953
Date: Tue, 22 Jan 2008 23:33:49 +0100
$PBExportHeader$d_pfcsecurity_report_by_window.srd
$PBExportComments$Reports all users/groups that are set for a specific window
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=364 color="536870912" )
summary(height=0 color="536870912" )
footer(height=96 color="536870912" )
detail(height=64 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="PBSELECT( VERSION(400) TABLE(NAME=~"security_apps~" )  TABLE(NAME=~"security_info~" )  TABLE(NAME=~"security_template~" )  TABLE(NAME=~"security_users~" ) COLUMN(NAME=~"security_info.user_name~") COLUMN(NAME=~"security_users.description~") COLUMN(NAME=~"security_apps.application~") COLUMN(NAME=~"security_apps.description~") COLUMN(NAME=~"security_info.window~") COLUMN(NAME=~"security_info.control~") COLUMN(NAME=~"security_template.description~") COLUMN(NAME=~"security_template.object_type~") COLUMN(NAME=~"security_info.status~") COLUMN(NAME=~"security_users.priority~") COLUMN(NAME=~"security_users.user_type~")    JOIN (LEFT=~"security_apps.application~"    OP =~"=~"RIGHT=~"security_info.application~" )    JOIN (LEFT=~"security_info.application~"    OP =~"=~"RIGHT=~"security_template.application~" )    JOIN (LEFT=~"security_info.window~"    OP =~"=~"RIGHT=~"security_template.window~" )    JOIN (LEFT=~"security_info.control~"    OP =~"=~"RIGHT=~"security_template.control~" )    JOIN (LEFT=~"security_info.user_name~"    OP =~"=~"RIGHT=~"security_users.name~" )WHERE(    EXP1 =~"( ( security_info.window~"   OP =~"=~"    EXP2 =~":win_name ) )~" ) ) ARG(NAME = ~"win_name~" TYPE = string) " arguments=(("win_name", string))  sort="security_info_control A priority A user_group_name A " )
column(band=header id=3 alignment="0" tabsequence=32766 border="0" color="0" x="407" y="168" 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 alignment="1" text="Description :"border="0" color="0" x="1184" y="168" 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" )
text(band=header alignment="1" text="Application :"border="0" color="0" x="14" y="168" 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" )
column(band=header id=4 alignment="0" tabsequence=32766 border="0" color="0" x="1586" y="168" 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" )
line(band=header x1="5" y1="232" x2="3488" y2="228" pen.style="0" pen.width="9" pen.color="0"  background.mode="1" background.color="553648127" )
text(band=header alignment="2" text="Object Type"border="4" color="0" x="2030" y="304" 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" )
text(band=header alignment="2" text="Control"border="4" color="0" x="18" y="304" 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 alignment="2" text="Description"border="4" color="0" x="1198" y="304" 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 alignment="2" text="Group/User"border="4" color="0" x="2702" y="304" height="52" width="320"  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 alignment="2" text="User
Type"border="4" color="0" x="3031" y="252" height="104" width="178"  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 alignment="2" text="Priority"border="4" color="0" x="3223" y="304" height="52" width="183"  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 alignment="2" text="Status"border="4" color="0" x="2478" y="304" 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 alignment="0" text="PFC Security Report for Object ID : "border="0" color="0" x="9" y="24" height="64" width="1111"  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="3003" y="24" height="64" 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" )
column(band=header id=5 alignment="0" tabsequence=32766 border="0" color="0" x="1138" y="24" height="64" 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="-10" 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=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" )
column(band=detail id=9 alignment="2" 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=11 alignment="2" tabsequence=32766 border="0" color="0" x="3031" y="4" height="56" width="178" 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="2" background.color="16777215" )
column(band=detail id=10 alignment="1" tabsequence=32766 border="0" color="0" x="3223" y="4" height="56" width="183" format="[general]"  name=priority 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="2" background.color="16777215" )
column(band=detail id=1 alignment="0" tabsequence=32766 border="0" color="0" x="2702" y="4" height="56" width="320" 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" )
compute(band=footer alignment="1" expression="'Page ' + page() + ' of ' + pageCount()"border="0" color="0" x="2821" 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")