Can you please say me how to find user's and groups created in DB2 database? I search through lot of resurces but vain.

we have in oracle dba_users/all_users.....we have roles there but DB2 I have no idea since I am novice.

your response is much useful for me.

Thanks,
Shahnaz.

DB2 does not have users and groups defined within it. It uses external means (like the OS) to perform the security. All that DB2 stores is the authorizations of the users and groups.

Andy

If you will query the system catalog views for those authorizations (like syscat.schemaauth, syscat.tabauth, etc) you will get a list with all the users/groups that have privileges in your database. And you may suppose that this is the users and groups list.