Applies to r9 marts and later.
Description: the set up instructions for a mart in the erwin Data Modeler Workgroup Edition Implementation and Administration Guide say that the user who is typed into the mart configure window when performing the initialization of the repository needs to have the DBA role. Is there any way to not use the DBA Role when setting up an Oracle mart?
Also, can I use ONE role instead of two roles?
First, the instructions say to use two roles, MMINSTALL and MMUSER.
You can use one role instead.
Please see the below instructions:
Create a database in Oracle and execute the prerequisite script with roles connect, resource, select_catalog_role, Execute_catalog_role and Delete_catalog_role assigned to a USER "STEVE" instead of using the DBA Role.
NOTE: you can replace the user name STEVE with whatever user name you desire.
The prerequisite script is as follows:
CREATE TABLESPACE MMDATA datafile 'c:\r952mart\MMDATA.dbf' size 300m autoextend on;
CREATE TABLESPACE MMINDEX datafile 'c:\r952mart\MMINDEX.dbf' size 300m autoextend on;
CREATE temporary tablespace marttemp tempfile 'c:\r952mart\tempdata.dbf' size 300m autoextend on;
CREATE USER STEVE identified by STEVE default tablespace MMDATA temporary tablespace marttemp quota unlimited on MMDATA quota unlimited on mmindex;
CREATE ROLE mmuser;
GRANT CREATE SEQUENCE to mmuser;
GRANT CREATE TABLE to mmuser;
GRANT CREATE VIEW to mmuser;
GRANT DROP PUBLIC SYNONYM to mmuser;
GRANT CREATE PUBLIC SYNONYM to mmuser;
GRANT CREATE PROCEDURE to mmuser;
GRANT CREATE session to mmuser;
GRANT CREATE MATERIALIZED VIEW to mmuser;
GRANT mmuser to STEVE;
GRANT CONNECT to STEVE;
GRANT RESOURCE to STEVE;
GRANT select_catalog_role to STEVE;
GRANT Execute_catalog_role to STEVE;
GRANT Delete_catalog_role to STEVE;