Granting Privileges to a UNIX Group

From InterBase
Jump to: navigation, search

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 GRANT /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.