<%
'*** Get all the users belonging to the GRIDNAME_USER role
Set rsOfUsersInARole = objUsersRO.rsGetUsersBelongingToRole(gstrAppInstAbbr, UCase(gstrMBPName) & "_USER")
If Err.number <> 0 Then Call HandleError(Err.number,Err.Source,Err.Description, strPageName)
'*** Display each user belonging to the role
If Not (rsOfUsersInARole.EOF And rsOfUsersInARole.BOF) Then
While rsOfUsersInARole.EOF <> True
strUserName = Trim(rsOfUsersInARole.Fields("last_name").Value) & ", " & _
Trim(rsOfUsersInARole.Fields("first_name").Value)
strUserId = Trim(rsOfUsersInARole.Fields("user_id").Value)
%>
<%=strUserName%>
<%=strUserId%>
<% rsOfUsersInARole.MoveNext
Wend
Else
%>
No users in the <%=UCase(gstrMBPName)%>_USER role
<% End If
%>
Instance Roles with Access to This Grid
Role Name
Role User List
<% '*** Get all the roles for this instance
Set objSecurityRO = Server.CreateObject("ChvCITCSecurityMgr.clsSecurityRO")
Set rsOfRoles = objSecurityRO.rsGetRolesNotAssociatedToMBP(gstrAppInstAbbr)
If Err.number <> 0 Then Call HandleError(Err.number,Err.Source,Err.Description, strPageName)
'*** Loop through all the roles
If Not (rsOfRoles.EOF And rsOfRoles.BOF) Then
While not rsOfRoles.EOF
strRoleName = Cstr(rsOfRoles.Fields("GROUPNAME").Value)
strRoleNameToDisplay = strFixStringForDisplay(strRoleName)
'*** Write a row displaying the role name
%>
<%
'*** Destroy all objects
If Not (rsUsers Is Nothing) Then Set rsUsers = Nothing
If Not (rsOfUsersInARole Is Nothing) Then Set rsOfUsersInARole = Nothing
If Not (objUsersRO Is Nothing) Then Set objUsersRO = Nothing
If Not (objSecurityRO Is Nothing) Then Set objSecurityRO = Nothing
%>