<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="reference" name="authidlinkuser"/> | <col type="column" name="USERID"/> | <col type="reference" name="authidlinkgroup"/> | <col type="column" name="GROUPID"/> | </display_columns>
<reference name="authidlinkuser"> | <c_title></c_title> <reftype>table</reftype> <refvalue>Authority/authids</refvalue> <icon>images/icon-user.gif</refvalue> <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</refvalue> <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> |