At 08:39 PM 13/07/2005 +0000, you wrote:

>Hi all!
>
>Im new to firebird and Delphi as well. Recently I have started an
>application to develop (in Delphi7), and I have a problem. My
>application must be able to create new user account on a firebird
>server, but I cant figure out the SQL statment. It is possible to
>create user account with sql script from Delphi?

With an SQL script, no. An SQL script is nothing more or less than a batch
of SQL requests passed sequentially to a database. There is no SQL
statement that you can pass to a user database to enable you to perform
activities at the server level.

(As an aside, although the user accounts are maintained in the database
security.fdb or isc4.gdb - depending on your Firebird server version - this
is a special database, belonging to the server, that requires special
access privileges.)

What you are after is the Services API, an extra API that provides access
to server-level activity for applications. In general, the Services API
functions expose application-level access to the various server tools,
including the security maintenance tool GSEC.

In Delphi, this API is available through the service components. For
example, study the (very lean) Delphi help for TIBSecurityService.

You can also download a full suite of free service components
(TIBOSecurityService, et al.) that use IB Objects connectivity, instead of
Borland's IBX, by visiting www.mengoni.it.

For your needs, you might also find Dmitry Beloshitov's bdslib components
can do what you want. You can download them here:
http://www.ibobjects.com/ibocontributed.html

For the rest of it, you'll need to get yourself onto an appropriate Delphi
list. This list isn't a Delphi support forum....Borland's support for IBX
is pretty awful, but both IB Objects and FIBPlus have very active user lists.

./heLen