Hi All,

I am new to DB2.
Can anyone of you please tell me how can i get the list of DB users thru DB2 database.

thanx a ton in advance,
Pooja

In DB2, user id's and passwords are controlled by the operating system. Users logged into the operating system can have specific authorities for various objects or groups of objects. You can also grant authority at the operating system group level, in addition to the user id level.

The DB2 authorizations are stored in various DB2 System Catalog views such as:

SYSCAT.DBAUTH
SYSCAT.TABAUTH
SYSCAT.ROUTINEAUTH
SYSCAT.SCHEMAAUTH
etc.

You can see the defintion of these catalog views in the SQL Reference Vol 1, Appendix D.