hi,

I'm trying to execute a db2 query from unix shell script to find the all the schemas in the database which has a table - TAB_A in those schema and select permission for my user id on the table on that schema.

ie, i would pass arguments table name (TAB_A) and user id (matt02) and the select query should fetch me all the schemas which has a TAB_A and also have select privileges for matt02 on TAB_A.

thanks
matt

DB2 does not authorize by schema, only by table, or the entire database for certain athorities like DBADM. You can find the table authorities in SYSCAT.TABAUTH catalog view. Database level authorities are in SYSCAT.DBAUTH. To find the list of all tables, independent of authorizations granted, you would look in SYSCAT.TABLES (but check the table "type" since it includes other objects such as views, etc).