Virtual Memory Developers of System wrote:

> Even with problems in the creation of users on security.fdb. I will try
> to explain further.
> I am creating / changing user with IBO using the command alteruser.
> Both the inclusion in the amendment of this user working perfectly but
> I am not knowing verify that the user has inserted into this database
> and ai is the problem. If I try to include the user that already exists
> me returns an error of key.
> I need help to move this process and very grateful if someone can
> guide me.

Flavio - This used to be nice and easy when we could just read the security
database and do what ever we wanted. As you have found, the 'improved
security' can cause a number of annoying problems. I only access Firebird via
PHP now, so the security of users is managed outside of the database, and I
only need one user to access Firebird. In the past we said - look at the code
in ib_sql to see how you managed user entries, but I'm not sure that applies
so much today. It may be worth looking at Flamerobin as a more modern example
of how you do it?

--
Lester Caine - G8HFL
-----------------------------
Contact - http://home.lsces.co.uk/lsces/wiki/?page=contact
L.S.Caine Electronic Services - http://home.lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk//
Firebird - http://www.firebirdsql.org/index.php