<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"> | </actionScript> </action> | <action name="REMOVE_MEMBER"> | <c_title>Remove Member</c_title> <icon>images/trash.gif</icon> <actionScript name="getMemberToDelete" type="blank"> | </actionScript> </action> | <action name="REMOVE_GROUP"> | <c_title>Remove Group</c_title> <icon>images/trash.gif</icon> <actionScript name="getGroupToDelete" type="blank"> | </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> |