Subject | Re: [firebird-support] user/pass directed to single .gdb file |
---|---|
Author | Milan Babuskov |
Post date | 2009-03-05T17:49:45Z |
sjlukacs wrote:
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
> 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