Subject Re: [firebird-support] user/pass directed to single .gdb file
Author Milan Babuskov
sjlukacs wrote:
> allow a user to be attached, directed, or allowed into only a single gdb file?

Nothing built in, but you could do it via database triggers (FB 2.1+)
and some custom table with privileges.

Set up a table with privileges and create ON CONNECT trigger:

CREATE TRIGGER usercheck ACTIVE ON CONNECT POSITION 0
AS
BEGIN
if (not exists(select 1 from allowed_users
where user_name = current_user))
then exception connection_not_allowed;
END

--
Milan Babuskov
http://www.flamerobin.org
http://www.guacosoft.com