Subject Re: [firebird-support] There is a statment to retrieve user list ?
Author Thomas Steinmaurer
> In new FB version there is a CREATE/ALTER/DROP USER, but I need to list all
> users in my FB, there is a LIST USERS or a co-related select * from sysusers
> ?
> Not conected users, I know that it´s possible, but list all created users in
> my system.
> Today I use IBX Security to retrieve all them, but only to list users to
> other all operation I use IBObjects and DDL Statment do create/modify users
> from my system.
>
> Any help, will be welcome.

There is no DDL/DML statement to list the Firebird users stored in the
security database.


--
With regards,
Thomas Steinmaurer

* Firebird Foundation Committee Member
http://www.firebirdsql.org/en/firebird-foundation/

* Upscene Productions - Database Tools for Developers
http://www.upscene.com/

* My Blog
http://blog.upscene.com/thomas/index.php