<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="column" name="USERID"/> <col type="column" name="GROUPID"/> </display_columns> <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> |