About user roles
Each user role allows certain MySQL commands to be executed. There are four user roles, three of which you may assign to the users you create:
- Database Administrator The default user created with each new database; you as the DSM owner are the Database Administrator. This user role allows full administrative access to the database (MySQL commands: SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, GRANT, INDEX, ALTER, CREATE TEMPORARY TABLE, and LOCK TABLES). The Database Administrator User cannot be deleted or edited.
- Read Allows a user to browse a database (MySQL command: SELECT).
- Read/Write Allows a user to browse a database, insert new records, update records and delete records (MySQL commands: SELECT, UPDATE, ALTER and DROP).
- Full Access Gives user the same privileges as the Database Administrator except GRANT.
