Each user gets their own database, so when they request an account a database needs to be created for them as well as a username and password. Sorry if I did not make this clear.
Izabelle
| [reply] |
Can you re read Re: Creating a Firebird Database, radiantmatrix brings up a few good points here.
I think that you are feeding us little bits of a problem piece meal.
In your previous post you said the goal was to setup database accounts for users, no mention of instances.
In order to give advice we need to know exactly what you want to do.
A detailed description of what you of the tools you are using, the platform(s) you have to work on and the over all goal of the program is and any restrictions you have.
Martin
| [reply] |
Sorry for the poor structure of the question.
I am using Firebird 1.0 and Perl, running on different servers and using unix. I cannot upgrade Firebird due to time restrictions.
The goal of the program is to create a record in the users table of the security.fdb table and a database for a user, when requested. A print out of the username, database name and password is also produced.
I don't have much time to complete this so will have to use the isql approach suggested by svenXY, but thank you for your time and comments.
Izabelle
| [reply] |
Howdy!
One thing that may be causing confusion and frustration is the
way words like "database" and "account" and "user" are heavily
overloaded when you look at all the different RDBMSs together.
I work with Informix mostly, and their use of "database" means
something quite different from what it does in Oracle. In Oracle,
you'd have an "instance", where you'd have a "database in Sybase
or Informix. I don't know where Firebird fits into this, so it
may be that the references to "database" were appropriate usage
in the context of Firebird, but led you to erroneous conclusions
based on your database experience.
| [reply] |