how to list all tables for a users?

[lhugh]

I would like to list all the table that belong to John Doe a regular user in my database.

How do I do that in DB2? Thanks

 

[MarcLodge]

lhugh,
Could you define a little better the term 'belong to'? Do you mean those tables that John Doe has created, or do you mean those table that John Doe can access? Or something else?
Marc

 

[Crox]

perhaps you can do a query on SYSIBM tables, for example one on bind-timestamps and libraries.

 

[lhugh]

yah, i mean these talbes were created by John Doe

in oracle i would issue this

SELECT table_name
FROM DBA_TABLES
WHERE OWNER='JOHN DOE';

 

[MarcLodge]

lhugh,
Very similar in Oracle to what you do in DB2:
SELECT NAME, CREATOR
FROM SYSIBM.SYSTABLES
WHERE CREATEDBY = 'JOHN DOE'

Hope this helps
Marc

 

[lhugh]

Thank you Marc.