get a list of all users in db2

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Peter Postlbauer - 16 Mar 2006 15:29 GMT

Hi,
is there a way (script or command) to get a list of all existing db2-users?
Our system: Windows 2000 server and UDB 7.2 / 8.2
Is there also a way to get the same information for a database running on
AIX?
thanks for all hints,
peter

Reply to this Message

Raj - 16 Mar 2006 16:37 GMT

Users and groups in db2 is handled by the OS, use OS tools to find the
list of users

in AIX query /etc/group or /etc/passwd

Reply to this Message

Brian Tkatch - 16 Mar 2006 17:27 GMT

in NT, a command prompt and "NET USER". See NET HELP or NET HELP USER
for more info.

B.

Reply to this Message

Peter Postlbauer - 17 Mar 2006 08:23 GMT

Thanx for your hints, now I know, where to search. Also a good source is the
table sysibm.sysuserauth.
regards, peter.

Reply to this Message