|Main Product Category||Administration|
|Sub Category||Distributed Installation|
Use an Amazon RDS database instance to host the Contrast database for a distributed EOP Installation.
As documented here, the usual configuration for the Contrast database user is to grant all privileges using:
GRANT ALL PRIVILEGES ON *.* TO 'contrast'@'%';
With an RDS instance, even the admin user that is provided for managing your instance does not possess all privileges, so it will be impossible to configure the contrast user as suggested.
Instead, the maximum permission level you can set for the contrast user is as follows:
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, PROCESS, REFERENCES, INDEX, ALTER, SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER ON *.* TO 'contrast'@'%' WITH GRANT OPTION;
In addition to configuring the user as such, the following steps need also be taken to avoid errors: