Product Documentation

MySQL Services

Jun 05, 2015

CloudPortal Services Manager enables customers with Customer Administrator permissions to create and remove new MySQL databases. The number of databases that customers can create is configured when the MySQL service is provisioned.

MySQL User Roles and Permissions

User roles are comprised of MySQL permissions. The following table describes the permissions that are included in each role.
MySQL Permissions ReadOnly Role DBA Role User Role Full Role
SELECT X X X X
INSERT   X X X
UPDATE   X X X
DELETE   X X X
EXECUTE X X X X
SHOW VIEW   X   X
CREATE   X   X
ALTER   X   X
REFERENCES       X
INDEX   X   X
CREATE VIEW   X   X
CREATE ROUTINE   X   X
ALTER ROUTINE   X   X
DROP   X   X
CREATE TEMPORARY TABLES   X X X
LOCK TABLES   X X X