| Model |
ACL |
RBAC |
| Protection |
Protects tables only |
Protects all server objects |
| Roles |
3 roles |
Unlimited roles |
| Permissions |
5 permissions |
Over 200 permissions |
| Restrictions |
Not supported |
Supported |
| Inserts and Updates |
Combined in the WRITE permission |
Separate permissions for Insert and Update |
| Inheritance |
Permission inheritance not supported |
Permission inheritance supported |
| Users assigned to groups |
128 users per group |
Unlimited users per group |
| Groups assigned to users |
128 groups per user |
Unlimited groups per user |
| Group name restrictions |
Not case-sensitive, 31 ASCII characters max, spaces not allowed |
Case-sensitive, unlimited max characters, spaces allowed |
| Databases |
No concept of databases |
Independent security controls for databases |
| SQL layer |
protects the ISAM, CTDB, and JSON Action APIs, but it does not prevent the SQL layer from accessing this data |
protects all server APIs and layers, including ISAM, CTDB, JSON API, and SQL |
| Interactions with other models |
Independent from SQL authorization model |
Supersedes all other access control models |
| ADMIN group |
Can do everything but change ADMIN account's password or add/remove administrator accounts from the ADMIN group |
Has full control |
| GUEST account |
Built-in, belongs solely to the GUEST group which is the default group when unassigned to another, and is disabled by default |
Always disables the GUEST account |
| Group descriptions |
Up to 63 characters long |
Up to 63 characters long |
| Renaming groups or roles |
Cannot be changed once created. Can only be deleted and recreated |
Cannot be changed once created. Can only be deleted and recreated |