XML Table diff


<table name="db2authLab_masterView">

  <sql_name>DB2AUTHLAB_MASTERVIEW</sql_name>
  <singular_name>Master View</singular_name>
  <plural_name>Master View</plural_name>
  <inlinequery>
    <![CDATA[
      SELECT
          DB2AUTH.USERS.USERID AS USERID,
          DB2AUTH.GROUPS.GROUPID AS GROUPID
        FROM
          DB2AUTH.USERS
            FULL OUTER JOIN
              (DB2AUTH.GROUP_MEMBERSHIP
                RIGHT OUTER JOIN
                  DB2AUTH.GROUPS
                ON
                  DB2AUTH.GROUPS.GROUPID = DB2AUTH.GROUP_MEMBERSHIP.GROUPID)
            ON
              DB2AUTH.USERS.USERID = DB2AUTH.GROUP_MEMBERSHIP.USERID
        ORDER BY USERID
    ]]>
  </inlinequery>
  <description>
    A table listing all users and groups for the current instance. This table is the result of joining the USERS, GROUPS, and GROUP_MEMBERSHIP tables from the DB2AUTH schema.
  </description>
  <rows_per_page>50</rows_per_page>
  <order_by_index name="userid" direction="A"/>

  <display_columns>
    <col type="action" name="REMOVE_USER"/>
    <col type="reference" name="authidlinkuser"/>
    <col type="column" name="USERID"/>
    <col type="action" name="REMOVE_MEMBER"/>
    <col type="reference" name="authidlinkgroup"/>
    <col type="column" name="GROUPID"/>
    <col type="action" name="REMOVE_GROUP"/>
  </display_columns>

  <action name="REMOVE_USER">
    <c_title>Remove User</c_title>
    <icon>images/trash.gif</icon>
    <actionScript name="getUserToDelete" type="blank">
      <followOnAction condition="true" >
        <task>
          <assignSharedConstant name="USERID" type="blockValue">
            <value>USERID</value>
          </assignSharedConstant>
          <action name="confirmDeleteUser" type="confirm">
            <message>
              Confirm deletion of user: ?USERID??
            </message>
            <followOnAction condition="true">
              <task>
              </task>
            </followOnAction>
          </action>
        </task>
      </followOnAction>
    </actionScript>
  </action>
  <action name="REMOVE_MEMBER">
    <c_title>Remove Member</c_title>
    <icon>images/trash.gif</icon>
    <actionScript name="getMemberToDelete" type="blank">
      <followOnAction condition="true" >
        <task>
          <assignSharedConstant name="USERID" type="blockValue">
            <value>USERID</value>
          </assignSharedConstant>           <assignSharedConstant name="GROUPID" type="blockValue">
            <value>GROUPID</value>
          </assignSharedConstant>
          <action name="confirmDeleteMember" type="confirm">
            <message>
              Confirm deletion of user: ?USERID? from group: ?GROUPID??
            </message>
            <followOnAction condition="true">
              <task>
              </task>
            </followOnAction>
          </action>
        </task>
      </followOnAction>
    </actionScript>
  </action>
  <action name="REMOVE_GROUP">
    <c_title>Remove Group</c_title>
    <icon>images/trash.gif</icon>
    <actionScript name="getGroupToDelete" type="blank">
      <followOnAction condition="true" >
        <task>
          <assignSharedConstant name="GROUPID" type="blockValue">
            <value>GROUPID</value>
          </assignSharedConstant>
          <action name="confirmDeleteGroup" type="confirm">
            <message>
              Confirm deletion of group: ?GROUPID??
            </message>
            <followOnAction condition="true">
              <task>
              </task>
            </followOnAction>
          </action>
        </task>
      </followOnAction>
    </actionScript>
  </action>

  <reference name="authidlinkuser">
    <c_title></c_title>
    <reftype>table</reftype>     <refvalue>Authority/authids</refvalue>
    <icon>images/icon-user.gif</icon>
    <ref foreign_column_name="authid">
      <local_column_name>USERID</local_column_name>
    </ref>   </reference>
  <reference name="authidlinkgroup">
    <c_title></c_title>
    <reftype>table</reftype>     <refvalue>Authority/authids</refvalue>
    <icon>images/group.gif</icon>
    <ref
foreign_column_name="authid">
      <local_column_name>GROUPID</local_column_name>
    </ref>   </reference>
  <column name="USERID">
    <c_sql_name>USERID</c_sql_name>
    <c_title>User ID</c_title>
    <c_presentation>s</c_presentation>
    <c_drill>n</c_drill>
  </column>

  <column name="GROUPID">
    <c_sql_name>GROUPID</c_sql_name>
    <c_title>Group ID</c_title>
    <c_presentation>s</c_presentation>
    <c_drill>y</c_drill>
  </column>

</table>