user list

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Santhosh - 26 Jun 2006 06:32 GMT

Dear All

Can you guys please help me in displaying the list of users in a DB2
instance? I need the user ID, privileges etc .. I use Db2 8.1.X under
windows environment..

Is it possible to know the last login date for a user?

Regards
Santhosh

Reply to this Message

Mark A - 26 Jun 2006 09:11 GMT

> Dear All
>
[quoted text clipped - 6 lines]
> Regards
> Santhosh

Users in DB2 are controlled by the operating system. If you want to know
what operating system users or groups have been granted specific access to
DB2 resources, then check the DB2 catalog views (dbauth, tabauth, etc).
These views are documented in Appendix D of the SQL Reference vol 1.

DB2 cannot determine when someone logged on with a password to the operating
system, but it can track connections to DB2 via the db2audit facility.

Reply to this Message