467,209 Members | 1,376 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,209 developers. It's quick & easy.

get a list of all users in db2

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
Mar 16 '06 #1
  • viewed: 48598
Share:
3 Replies
Raj
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

Mar 16 '06 #2
in NT, a command prompt and "NET USER". See NET HELP or NET HELP USER
for more info.

B.

Mar 16 '06 #3
Thanx for your hints, now I know, where to search. Also a good source is the
table sysibm.sysuserauth.
regards, peter.
Mar 17 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by zsh-users-help@sunsite.dk | last post: by
2 posts views Thread by Arshad Parvez | last post: by
reply views Thread by AndersBj | last post: by
2 posts views Thread by Ryan Ternier | last post: by
5 posts views Thread by kpp9c | last post: by
18 posts views Thread by Grant Edwards | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.