Collecting Database Users

[Ruslan Zasukhin]

On 21/2/07 9:26 PM, "Bart Pietercil" <bart.pietercil at gmail.com> wrote:

> 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]

Yes this is a way.

And yes we need add "SHOW USERS" command yet to SQL.


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]