DB2 how to get user privilege information when privilege is granted to its group
<p>I grant schema CREATEIN privilege for schema '<strong>test</strong>' to user group '<strong>test-group</strong>', then add a user '<strong>test-user</strong>' into this '<strong>test-group</strong>' in Windows OS.</p>

<p>I would like to know what DB2 function or SQL statement can be used to retrieve privilege information for user '<strong>test-user</strong>'. I am aware of that the user-group relationship is not defined in DB2, but there must be some ways to look up such relationship data.</p>

<p>As an example, I can create a table successfully in schema '<strong>test</strong>' after log in database by user '<strong>test-user</strong>' which means the DB2 engine can get 'test-user' CREATEIN privilege inherited from '<strong>test-group</strong>'.</p>

<p>I tried to check syscat.schemaauth view by SQL statment 
 <code>select * from syscat.schemaauth</code> but cannot find user '<strong>test-user</strong>' privilege definition only group 'test-group' privilege definition:</p>

<pre><code>GRANTOR      GRANTORTYPE  GRANTEE GRANTEETYPE  SCHEMANAME   ALTERINAUTH   CREATEAUTH  DROPINAUTH
...  ....
SYSIBM          S          PUBLIC   G         ADMINISTRATOR N                Y          N
ADMINISTRATOR   U          TEST     G          TEST         N                Y          Y
.. ...
</code></pre>