469,366 Members | 2,254 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,366 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
3 49897
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 | 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
1 post views Thread by CARIGAR | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.