<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> |