Database Users

The system uses two users to access the database, each with a different level of authority.

Restricted User. This is the account used by the public interface. The database user only has create (INSERT), delete (DELETE), update (UPDATE), and select (SELECT) privileges; the latter is only available for queries.
Although privilege checking is always performed before access is granted, it does prevent more complex commands (DROP, REMOVE, ALTER, etc.) from being executed by mistake. Sometimes it will also be necessary to have lock privileges (LOCK).

Privileged User. This is the account used by system administrators. It has all privileges, allowing tables to be created, deleted, created temporary tables, etc.