Subject | Best way to maintain users between two or more FB/IB servers |
---|---|
Author | Steve |
Post date | 2010-06-15T19:03:29Z |
Hi All,
I have been trying to juggle several servers with
Interbase/Firebird on them and have been having to
do a lot of work to be able to maintain security
between them. Users want to be able to use the same
logon and password when they are using one database
on one server and a different database on a different
server.
Currently I have been having to add the user with a
fixed password to each of the IB/FB security DB and then
add them to the individual databases with the user name
for that database's server.
Example: A wants password P on server S1 and server S2
with databases DB1 on S1 and DB2 on S2. I have to add
that person to the ISC database using IBOConsole, etc
on each server and then use another program, such as
IBAccess to add them to the database using a default Role.
The username and password needs to span the whole domain
at times.
Does anyone have an easier way that they are doing it and
can say.
Thanks,
Steve Fields
I have been trying to juggle several servers with
Interbase/Firebird on them and have been having to
do a lot of work to be able to maintain security
between them. Users want to be able to use the same
logon and password when they are using one database
on one server and a different database on a different
server.
Currently I have been having to add the user with a
fixed password to each of the IB/FB security DB and then
add them to the individual databases with the user name
for that database's server.
Example: A wants password P on server S1 and server S2
with databases DB1 on S1 and DB2 on S2. I have to add
that person to the ISC database using IBOConsole, etc
on each server and then use another program, such as
IBAccess to add them to the database using a default Role.
The username and password needs to span the whole domain
at times.
Does anyone have an easier way that they are doing it and
can say.
Thanks,
Steve Fields