There are three different profiles that can be assigned to a user (in relation to the database):
- Lite Admin: full read, write and delete permissions for the database.
The user can read and edit data in the tables, add new records, create and delete tables and change the structure of existing tables.
| MySQL |
Microsoft SQL Server |
PostgreSQL |
ALTER ALTER ROUTINE CREATE CREATE ROUTINE CREATE TEMPORARY TABLES CREATE VIEW DELETE DROP EXECUTE INDEX INSERT LOCK TABLES REFERENCES SELECT SHOW VIEW TRIGGER UPDATE |
ALTER CREATE DEFAULT CREATE FUNCTION CREATE PROCEDURE CREATE RULE CREATE TABLE CREATE VIEW DELETE EXECUTE INSERT REFERENCES SELECT UPDATE VIEW DATABASE STATE |
ALTER CREATE TABLE CREATE VIEW CREATE PROCEDURE CREATE FUNCTION CREATE RULE CREATE DEFAULT SELECT INSERT UPDATE DELETE EXECUTE VIEW DATABASE STATE |
| MySQL |
ALTER ALTER ROUTINE CREATE CREATE ROUTINE CREATE TEMPORARY TABLES CREATE VIEW DELETE DROP EXECUTE INDEX INSERT LOCK TABLES REFERENCES SELECT SHOW VIEW TRIGGER UPDATE |
| Microsoft SQL Server |
ALTER CREATE DEFAULT CREATE FUNCTION CREATE PROCEDURE CREATE RULE CREATE TABLE CREATE VIEW DELETE EXECUTE INSERT REFERENCES SELECT UPDATE VIEW DATABASE STATE |
| PostgreSQL |
ALTER CREATE TABLE CREATE VIEW CREATE PROCEDURE CREATE FUNCTION CREATE RULE CREATE DEFAULT SELECT INSERT UPDATE DELETE EXECUTE VIEW DATABASE STATE |
- Read/Write: read and write permissions for the database.
The user can add, read, edit and delete records in the tables.
The user cannot create new tables, delete existing tables or change their structure.
| MySQL |
Microsoft SQL Server |
PostgreSQL |
ALTER CREATE TEMPORARY TABLES DELETE EXECUTE INDEX INSERT LOCK TABLES SELECT SHOW VIEW UPDATE |
DELETE INSERT SELECT UPDATE |
DELETE INSERT SELECT UPDATE |
| MySQL |
ALTER CREATE TEMPORARY TABLES DELETE EXECUTE INDEX INSERT LOCK TABLES SELECT SHOW VIEW UPDATE |
| Microsoft SQL Server |
DELETE INSERT SELECT UPDATE |
| PostgreSQL |
DELETE INSERT SELECT UPDATE |
- Read Only: read only permission for the database.
The user has read only access to the entire database but never has write permissions. The user can read the records in the different tables, without being able to change them in any way. This profile is automatically assigned to the user if there is
insufficient credit to renew the service.
| MySQL |
Microsoft SQL Server |
PostgreSQL |
DELETE DROP SELECT SHOW VIEW |
SELECT |
SELECT |
| MySQL |
DELETE DROP SELECT SHOW VIEW |
| Microsoft SQL Server |
SELECT |
| PostgreSQL |
SELECT |
| User profile |
Shared resources |
Dedicated resources |
| Lite Admin |
|
|
| Read/Write |
|
|
| Read Only |
|
|
When the service has shared resources (both for MySQL and for Microsoft SQL Server), the system creates just one user with full permissions for the single database.
| User profile |
read |
write |
delete |
| Lite Admin |
|
|
|
When the service has dedicated resources (MySQL, Microsoft SQL Server, PostgreSQL) you can create several users and assign one or more profiles to them, for one or more databases.
| User profile |
read |
write |
delete |
| Lite Admin |
|
|
|
| Read/Write |
|
|
|
| Read Only |
|
|
|
Please note that there must always be at least one user with a "Lite Admin" profile.