Rev 5354 | Go to most recent revision | Blame | Compare with Previous | Last modification | View Log | RSS feed
<%@LANGUAGE="VBSCRIPT"%><%'====================================================='' User Override' User_Override.asp''=====================================================%><%Option explicitResponse.Expires = 0%><!--#include file="common/globals.asp"--><!--#include file="common/config.asp"--><!--#include file="common/common_subs.asp"--><!--#include file="common/_user_common.asp"--><%'------------ ACCESS CONTROL ------------------%><!--#include file="_access_control_general.asp"--><%'------------ VARIABLE DEFINITION -------------Dim RoleIdDim sNodeDim rsQryDim ActiveComboDim VisibleComboDim objAppCollectorDim CanEdit'------------ CONSTANTS DECLARATION -----------'------------ VARIABLE INIT -------------------Set objAppCollector = CreateObject("Scripting.Dictionary")CanEdit = canActionControl("canEditUserOverrides")'------------ CONDITIONS ----------------------'----------------------------------------------%><%'------------------------------------------------------------------------------------------------------------------------------------------------------Sub SetPermissionCombos ( nObj_id, cVisible, cActive, ByRef outVisibleCombo, ByRef outActiveCombo )Dim i, selected, disableControl' -- Disable editingIf CanEdit ThendisableControl = ""ElsedisableControl = " disabled"End IF' --- Visible Combo ---outVisibleCombo = ""outVisibleCombo = outVisibleCombo &"<select name='VIS_"& nObj_id &"' class='form_iname'" & disableControl &">"For i = 0 To UBound( arrVisiblePermissions ) Step NumberofPermissionFieldsselected = ""If arrVisiblePermissions( INXperm_val + i ) = cVisible Thenselected = "selected"End IfoutVisibleCombo = outVisibleCombo &"<option class='"& arrVisiblePermissions( INXperm_style + i ) &"' "& selected &" value='"& arrVisiblePermissions( INXperm_val + i ) &"'>"& arrVisiblePermissions( INXperm_text + i ) &"</option>"& VBNewLineNextoutVisibleCombo = outVisibleCombo &"</select>"' --- Active Combo ---outActiveCombo = ""outActiveCombo = outActiveCombo &"<select name='ACT_"& nObj_id &"' class='form_iname'" & disableControl &">"For i = 0 To UBound( arrActivePermissions ) Step NumberofPermissionFieldsselected = ""If arrActivePermissions( INXperm_val + i ) = cActive Thenselected = "selected"End IfoutActiveCombo = outActiveCombo &"<option class='"& arrActivePermissions( INXperm_style + i ) &"' "& selected &" value='"& arrActivePermissions( INXperm_val + i ) &"'>"& arrActivePermissions( INXperm_text + i ) &"</option>"& VBNewLineNextoutActiveCombo = outActiveCombo &"</select>"End Sub'------------------------------------------------------------------------------------------------------------------------------------------------------'-----------------------------------------------------------------------------------------------------------------Sub GetUserRoleDetails ( nUser_id)Dim rsQry, queryquery = _"SELECT r.ROLE_ID " &_" FROM ROLES r, USER_ROLES ur WHERE " &_" r.IS_ROLE_VARIATION IS NOT NULL AND" &_" ur.ROLE_ID = r.ROLE_ID" &_" AND ur.USER_ID = " & nUser_idSet rsQry = OraDatabase.DbCreateDynaset( query , ORADYN_DEFAULT )If ((NOT rsQry.BOF) AND (NOT rsQry.EOF)) ThenRoleId = rsQry("role_id")ElseRoleId = NULLEnd IfrsQry.CloseSet rsQry = NothingEnd Sub%><%'------------ RUN BEFORE PAGE RENDER ----------Call GetUserDetails ( parUser_id, objUserCollector )Call GetApplicationDetails ( parApp_id, objAppCollector )Call GetUserRoleDetails ( parUser_id )'----------------------------------------------%><html><head><title>Access Manager</title><link rel="shortcut icon" href="<%=FavIcon%>"/><meta HTTP-EQUIV="Pragma" CONTENT="no-cache"><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"><link href="scripts/access_manager.css" rel="stylesheet" type="text/css"><script language="JavaScript" src="scripts/common.js"></script></head><body bgcolor="#FFFFFF" leftmargin="0" topmargin="0"><!-- HEADER ++++++++++++++++++++++ --><!--#include file="_header.asp"--><!-- +++++++++++++++++++++++++++++ --><table width="100%" border="0" cellspacing="0" cellpadding="0"><tr><td width="1%" valign="top" background="images/bg_bage_pane.gif"><!-- TREE NAVIGATOR ++++++++++++++++++++++++++++++++++++++++++++ --><!--#include file="_treeNavigator.asp"--><!-- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++ --></td><td width="1" background="images/bg_drk_gray_border.gif"><img src="images/spacer.gif" width="1" height="600"></td><td width="100%" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="9"><tr><td background="images/bg_drk_bage_pane.gif"><table width="100%" border="0" cellspacing="0" cellpadding="0"><tr><td nowrap class="body_txt"><!-- BUTTONS CONTROL +++++++++++++++++++ --><!-- +++++++++++++++++++++++++++++++++++ --></td><td align="right" nowrap class="section_ttl"><%=PARENT_TITLE%></td></tr></table></td></tr><tr><td class="menu_crumbttl"><%Call RenderTitle ( objUserCollector )%> Application: <%=objAppCollector.Item ("application_name")%></td></tr><tr><td><!-- DETAILS ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ --><!-- TAB CONTROLS ++++++++++++++++++++++ --><!--#include file="_tabs_definition.asp"--><%Set objTabControl = New TabControlobjTabControl.TemplateDoc = ReadFile( Server.MapPath("controls/ERGTabStyleMac/mac_style.html") ) ' Supply tab style definitionobjTabControl.TabStyle = "StyleMac"objTabControl.AddTabDefnition ( arrUserAccount )objTabControl.SelectByName ( "User Override" )objTabControl.Render ()%><!-- END OF TAB CONTROLS +++++++++++++++ --><table width="100%" border="0" cellspacing="0" cellpadding="0"><tr><td width="1" background="images/bg_gray_border.gif"><img src="images/spacer.gif" width="1" height="500"></td><td width="100%" valign="top"><table width="100%" border="0" cellspacing="10" cellpadding="0"><tr><td><!-- TAB DETAILS +++++++++++++++++++++++++++++ --><%Call Messenger ( "Any permission changes will be appled to this user only!", 3, 400 )%><br><table width="100%" border="0" cellspacing="3" cellpadding="0"><form name="UserPrivileges" action="_SetUserOverridePermissions.asp" method="post"><tr><td width="30%" background="images/bg_table_border.gif"><table width="100%" border="0" cellspacing="1" cellpadding="2"><tr><td align="right" nowrap background="images/bg_table_col.gif" class="body_col">Action Name</td></tr></table></td><td width="1%" align="right" nowrap background="images/bg_table_col.gif" class="body_col">Permissions</td><td width="70%" align="right" background="images/bg_table_col.gif" class="body_col">Description</td><td width="1%" background="images/bg_table_col.gif"></td></tr><%OraDatabase.Parameters.Add "USER_ID", parUser_id, ORAPARM_INPUT, ORATYPE_NUMBEROraDatabase.Parameters.Add "APP_ID", parApp_id, ORAPARM_INPUT, ORATYPE_NUMBEROraDatabase.Parameters.Add "ROLE_ID", RoleId, ORAPARM_INPUT, ORATYPE_NUMBERSet rsQry = OraDatabase.DbCreateDynaset( GetQuery ("UserOverride.sql") , ORADYN_DEFAULT )While (NOT rsQry.BOF) AND (NOT rsQry.EOF)Call SetPermissionCombos ( rsQry("obj_id"), rsQry("visible_value"), rsQry("active_value"), VisibleCombo, ActiveCombo )%><tr><td nowrap class="body_row"><a href="Control_General.asp?obj_id=<%=rsQry("obj_id")%>&<%=objPMod.ComposeURL%>" class="body_link"><%=Eval(rsQry("TYPE")) & rsQry("obj_name")%></a></td><td class="body_txt" nowrap background='images/bg_bage_pane.gif'> <%=VisibleCombo%> <%=ActiveCombo%> </td><td class="body_rowg"><%=rsQry("obj_description")%></td><td><%If RoleId <> "" Then %><a href="Role_DataFiltering.asp?obj_id=<%=rsQry("obj_id")%>&role_id=<%=RoleId%>&<%=objPMod.ComposeURL%>" class="body_link"><%=EVal( rsQry("data_filter") )%></a></td><%End If%></tr><%rsQry.MoveNext%><tr><td colspan="5" background="images/bg_table_border.gif"><img src="images/spacer.gif" width="1" height="1"></td></tr><%WEndOraDatabase.Parameters.Remove "USER_ID"OraDatabase.Parameters.Remove "APP_ID"OraDatabase.Parameters.Remove "ROLE_ID"%><%If CanEdit Then %><tr><td class="body_txt"></td><td align="center" background='images/bg_bage_pane.gif'><input type="submit" name="btn" value="Apply" class="form_btn"></td><td class="body_txt"></td></tr><%End If%><tr><td colspan="5" background="images/bg_table_border.gif"><table width="100%" border="0" cellspacing="1" cellpadding="2"><tr><td nowrap background="images/bg_table_col.gif"><img src="images/spacer.gif" width="1" height="1"></td></tr></table></td></tr><%=objPMod.ComposeHiddenTags()%><input type="hidden" name="role_id" value="<%=RoleId%>"><input type="hidden" name="rfile" value="<%=SCRIPT_NAME%>"></form></table><SPAN class="body_txtg"><b>NOTE:</b> "User Specific" Role (<%=LIMG_SPEC_ROLE%>), will overwrite the permissions given by other roles.</SPAN><!-- +++++++++++++++++++++++++++++++++++++++++ --></td></tr></table></td><td width="1" background="images/bg_gray_border.gif"><img src="images/spacer.gif" width="1" height="1"></td></tr></table><table width="100%" border="0" cellspacing="0" cellpadding="0"><tr><td background="images/bg_gray_border.gif"><img src="images/spacer.gif" width="1" height="1"></td></tr></table><!-- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ --><br></td></tr></table></td></tr></table><!-- FOOTER ++++++++++++++++++++++ --><!--#include file="_footer.asp"--><!-- +++++++++++++++++++++++++++++ --></body></html><%'------------ RUN AFTER PAGE RENDER -----------'----------------------------------------------%><!--#include file="common/globals_destructor.asp"-->