Basic and Advanced Authorization Comparison

 

  Basic Advanced
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