Collecting Database Users

[Bart Pietercil]

Hi List,Ruslan,

I need to obtain the existing users in a VServer.

1) Is there an "SQL way" of doing this ?

2) if not (and using RB) is this the way to go ?

[pseudocode]

  Dim arUsers() as String
Dim x = VServer.usercount

For i = 1 to x ---> 1based index ?
	if not GetUserIsAdmin(i) Then// I only need non-admins
   		arUsers.append(GetUserName(i))
	end if
Next
[end_pseudocode]

TIA

Bart Pietercil