Subject | Groups in Firebird |
---|---|
Author | Sérgio Marcelo @ Smace . com . BR |
Post date | 2004-10-21T21:32:06Z |
I'd like to have "Groups of grants" in Firebird. I know an easy way of doing
it. Who should I talk to make it happen?
--
One way is adding RDB$GROUPS table like RDB$ROLES.
CREATE TABLE RDB$GROUPS (
RDB$GROUP_NAME CHAR(31) CHARACTER SET UNICODE_FSS,
RDB$OWNER_NAME CHAR(31) CHARACTER SET UNICODE_FSS
);
And then replacing RDB$SECURITY_CLASSES by one View instead of table. This
view catches all data from RDB$RELATION_FIELDS and *automatically adds
grants (from the groups) (thought one select, union (whatever). I belive.
It's not so hard doing. As you can see. So, I'd like to implement it. But I
am not sure about changing RDB$ tables. And how we can add it to the default
firebird distro.
Am I sending this msg to the right Firebird group?
--
I hope someone helps me. Thank you all.
[]'s
Sérgio Marcelo
smace@...
[Non-text portions of this message have been removed]
it. Who should I talk to make it happen?
--
One way is adding RDB$GROUPS table like RDB$ROLES.
CREATE TABLE RDB$GROUPS (
RDB$GROUP_NAME CHAR(31) CHARACTER SET UNICODE_FSS,
RDB$OWNER_NAME CHAR(31) CHARACTER SET UNICODE_FSS
);
And then replacing RDB$SECURITY_CLASSES by one View instead of table. This
view catches all data from RDB$RELATION_FIELDS and *automatically adds
grants (from the groups) (thought one select, union (whatever). I belive.
It's not so hard doing. As you can see. So, I'd like to implement it. But I
am not sure about changing RDB$ tables. And how we can add it to the default
firebird distro.
Am I sending this msg to the right Firebird group?
--
I hope someone helps me. Thank you all.
[]'s
Sérgio Marcelo
smace@...
[Non-text portions of this message have been removed]