How to add a new user to the firebird? HELP!!!
lazarus / 16-Databases

----------------------------------------------------------------------
abmservice · 2010-07-21 17:46

How to add a new user to the firebird?
Lazarus and the software - supposedly the firebirdAPI I do not know
how?

----------------------------------------------------------------------
Troodon · 2010-07-21 17:55

http://www.firebirdsql.org/?op=doc#category_0

----------------------------------------------------------------------
abmservice · 2010-07-22 04:15

I am not an advanced programmer and suggestions so please. if someone
did something similar?

----------------------------------------------------------------------
JD · 2010-07-22 05:41

Quote from: abmservice on July 22, 2010, 06:15:01 amI am not an
advanced programmer and suggestions so please. if someone did
something similar?

I would suggest that you use a GUI database management tool such as
the free IBExpert Personal Edition
http://ibexpert.net/ibe/index.php?n=Main.PersonalEdition to help with
managing Firebird databases. It is a much better alternative than
using command line DOS commands that are required to create tables,
add users, run sql queries etc. It will save you a lot of time &
headaches.

----------------------------------------------------------------------
Lacak2 · 2010-07-22 05:47

Starting from Firebird 2.5 there is SQL statement "CREATE USER"
Before 2.5 you must use Services API call (fbclient.dll) with
isc_action_svc_add_user ...
look at above mentioned http://www.firebirdsql.org/?op=doc#category_9
and there at "InterBase 6.0 Manuals" / "API Guide"

or try googling for "isc_action_svc_add_user" ;-)

----------------------------------------------------------------------
JD · 2010-07-22 07:14

You can use the gsec utility

http://www.firebirdsql.org/manual/qsg2-config.html

The text below was taken from the website above
Code: [Select]Adding Firebird user accounts

Firebird allows the creation of many different user accounts. Each of
them can own databases and also have various types of access to
databases and database objects it doesn't own.

Using gsec, you can add a user account as follows from the command
line in the Firebird bin subdirectory:

    gsec -user sysdba -pass masterkey -add billyboy -pw sekrit66

Provided that you've supplied the correct password for SYSDBA, a user
account called billyboy will now have been created with password
sekrit66. Remember that passwords are case-sensitive.

----------------------------------------------------------------------
abmservice · 2010-07-22 14:24

IBExpert know:)
gsec also know:)
But I wanted to do it in a Lazarus in the application-no, and
succeeded. isc_add_user gds32.dll library. I have to play around with
the editing and even deleting. I do not like half-measures.

firebird and application written in Lazarus works already implemented
in a large Polish company. Database after 15 days is already 63 MB.
Spent a day is about 1,000 documents. A server is a Core2Quad and
5-positions of the client. Lazarus and Firebird are more and more
fascinating. So I consider the Polish site devoted to this subject.

----------------------------------------------------------------------
JD · 2010-07-22 19:22

Quote from: abmservice on July 22, 2010, 04:24:03 pmfirebird and
application written in Lazarus works already implemented in a large
Polish company. Database after 15 days is already 63 MB. Spent a day
is about 1,000 documents. A server is a Core2Quad and 5-positions of
the client. Lazarus and Firebird are more and more fascinating. So I
consider the Polish site devoted to this subject.

Sweet music to my ears. Let's keep writing serious applications using
Lazarus. Object Pascal is alive & well.