What you could try, is to download IB_SQL (www.ibobjects.com). Type in the database name, username and password and click on the head with a question mark. That should give you a list of connected users. Clicking the other head gives you the ability to add, modify or delete users.

It doesn't have anything to list all registered users (AFAIK, I could well be wrong). I do have access to the source code of IB_SQL, but I don't know whether this is generally available as a sample or if it has something to do with the IBO license that we have. I think IB_SQL.exe itself is freeware.

HTH,
Set

-----Original Message-----
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Michael Vilhelmsen
Sent: 15. oktober 2008 12:56
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: FB Users

Well

Well ...
I have a problem, which I dont know how to solve right now (im
googling and strugling).

I have an application as mentioned using IBX - Only thing is does is
displaying users. I can then add, delete or modify users.

I use IBXs TIBSecurityService to do this.
I connect to an Firebird 1.5-5.4926

I get an error after retrieving some 1307 users.
Its is UNEXPECTED OUTPUT BUFFER VALUE.

I have then tried to following:

Same program but using FIBPLus component (TpFIBSecurityService)
Same problem.

Backup of security and restore (even on another machine).
Same problem.

I can still add a use. Everyone allready added can login.
I just cant display users anymore.

Is there any other tool - besides GSEC - that can be used to retrieve
user information ?
IBObjects?

When in GSEC - I can write DI.
This will list the users.
Is there any way I can count how many has been listed?

Meanwhile I'll strugle on.

Michael



--- In firebird-support@yahoogroups.com, "Michael Vilhelmsen"
<Michael.Vilhelmsen@...> wrote:

>
> Hi
>
> I have made a very small application which uses IBXs
> TIBSecurityService to retrieve user information and to maintain users
> on a Firebird server.
>
> I just discovered an error which Im not sure of.
>
> We have 4 servers.
> On one them, I get this error when I want to view all created users
>
> Unexpected Output Buffer Value.
>
> But if I try to do the same in FlameRobin I get all users returned

to me.

>
>
> So I know it must be something to do with IBX.
>
> Has anyone experienced this and maybe know a fast work around ?
>
> Otherwise this application will be switched to use FIBPlus (will be
> anyway, wasnt just planned to be now).
>
> Michael