community.borland.com

Article #25701: What's an ACL?

Problem:
What's an ACL?  When are they used?

Solution:
Note:  The information in this document pertains to InterBase 3.3.


The acronym ACL, stands for Access Control List.   The access control list defines the access
of individual users, groups or views in a security class.     The access control list is defined by using the
'define security class' statement in GDML.     In order to define a security class, you must
have write access to the system table, RDB$SECURITY_CLASSES.     

Here is an example of defining a security class:

modify database 'personnel.gdb'
define security_class salary_access
[201,114] rwdcp,
[201,*] r ;

This syntax creates an access control list that allows user 114 of group 201 full access (rwdcp).   All other
users of group 201 are only allowed read access ( r ).

Last Modified: 23-OCT-00