Subject | RE: [firebird-support] Adding new user with sql script |
---|---|
Author | Alan McDonald |
Post date | 2005-07-13T23:44:15Z |
> Hi all!users are created on the server in security.fdb, not your own database.
>
> 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?
>
> Kr152ta
>
There is no standard SQL to do this. Standard SQL executed against
security.fdb is possible but the password will not be encrypted as it would
by using the API or GSEC.
There are several 3rd party component sets which assist in the this whole
venture though.
e.g. the contributed code at www.ibobjects.com has some nice components
which provide a means of adding users etc. If you want users to edit their
own password, then you will need to make some changes to the security.fdb -
for which you need to read carefully, the Firebird book to understand what
needs to be done.
You also need to decide how you manage the SYSDBA password because you need
this to add/edit users.
Alan