Subject RE: [firebird-support] user/pass directed to single .gdb file
Author Alan McDonald
> hello one and all,
> is there a way, like under gsec, to allow a user to be attached,
> directed, or allowed into only a single gdb file? this way when that
> user logs into the database with their username and password, that they
> are only allowed into that one database.
> thank you in advance. lucas

short answer, no
long answer, with some way of ensuring that all connections are made with a
role (your client), and by ensuring that no 2 databases have the same role
name in existence (e.g. use role prefixes specific to DBs if necessary),
then you may be able to limit access to DBs where that role does not exist.