On Tue, Jul 26, 2011 at 10:25 AM, Thomas Steinmaurer <ts@...>wrote:

> **
>
>
> Hello Thomas,
>
>
> > I am using a 2.5 superserver database accessed from a Delphi application.
> I
> > want to allow a master user to add, modify and delete users. I can use
> the
> > create user, alter user and drop user SQL commands for this. My problem
> is I
> > want to list all current users of the database in a grid. I found the
> > following query:
> >
> > select distinct rdb$user
> > from rdb$user_privileges
> >
> > But it displays users after they have been dropped.
> >
> > Does anyone know of a query that can list the users of a database from
> the
> > system tables?
>
> Users are stored instance/server wide in a database called security2.fdb.
>
> What you are querying are the privileges on database objects (tables,
> views, ...) granted to users/roles/procedures for the database you are
> currently connected to.
>
> Use the command-line tool gsec to get the available users for the
> instance/server located in the Firebird bin directory.
>
> --
> With regards,
>
> Thomas Steinmaurer
> Upscene Productions
> http://www.upscene.com
> http://blog.upscene.com/thomas/
>
> Download LogManager Series, FB TraceManager today!
> Continuous Database Monitoring Solutions supporting
> Firebird, InterBase, Advantage Database, MS SQL Server
> and NexusDB!
>
>
>

Hi Thomas,

I understand and acknowledge what you are saying. I wanted a way to find and
list the users in my application without having to shell out to another
application. It is done in the IBExpert tool. I wanted to emulate this.

Thanks.

Thomas Clarke
Cyber Sea Incorporated
#6 Kingston Terrace
Flint Hall
St. Michael
Barbados BB11070

voice: (246) 234-9692
email: tclarke@...
web: http://cybersea.biz


[Non-text portions of this message have been removed]