Granting Privileges to a UNIX Group
OS-level account names are implicit in InterBase security on UNIX. A client running as a UNIX user adopts that user identity in the database, even if the account is not defined in the InterBase security database. Now OS-level groups share this behavior, and database administrators can assign SQL privileges to UNIX groups through SQL
REVOKE statements. This allows any OS-level account that is a member of the group to inherit the privileges that have been given to the group. For example:
GRANT UPDATE ON table1 TO GROUP group_name;
where group_name is a UNIX-level group defined in /etc/group.
- Note: Integration of UNIX groups with database security is not a SQL standard feature.