Privileges
In a role-based access control system, a privilege represents a specific action or permission that a user or role is allowed to perform within the system. It defines what a user can or cannot do, such as reading, writing, or managing certain resources like tables, databases, or settings. Essentially, a privilege is a right or ability granted to a user or role, specifying their level of access and control over the system's resources.
A privilege can be granted, revoked and assigned to a given role. A role can contains any combination of privileges.
>> LIST PRIVILEGES
-----------------|
name |
-----------------|
NONE |
READ |
INSERT |
UPDATE |
DELETE |
READWRITE |
PRAGMA |
CREATE_TABLE |
CREATE_INDEX |
CREATE_VIEW |
CREATE_TRIGGER |
DROP_TABLE |
DROP_INDEX |
DROP_VIEW |
DROP_TRIGGER |
ALTER_TABLE |
ANALYZE |
ATTACH |
DETACH |
DBADMIN |
SUB |
PUB |
PUBSUB |
BACKUP |
RESTORE |
DOWNLOAD |
PLUGIN |
SETTINGS |
USERADMIN |
CLUSTERADMIN |
CLUSTERMONITOR |
CREATE_DATABASE |
DROP_DATABASE |
HOSTADMIN |
SWITCH_USER |
PUBSUBCREATE |
PUBSUBADMIN |
WEBLITE |
ADMIN |
-----------------|