4.2.3 Create the MMG Studio Schema

You must create an Oracle User to create the MMG Studio Schema. For more details, see Creating an Oracle User section.

Assign the following grants:

GRANT CONNECT, CREATE TABLE, CREATE VIEW, CREATE SEQUENCE TO <mmgstudio_schema_name>;

A new user group created in MMG which requires permission for Studio operations, is to be added in the following files:
  • mmgstudio/conf/application.yml
  • mmgstudio/conf/ofsaa-permissions.init.yml

Note:

Make sure the groups are in upper case, as AAI groups are always in upper case.