CARIS HPD : Database Administration : Exporting and Importing HPD Schemas (Oracle) : Import a Previously Exported Database Schema : Check the HPD Roles
 

Check the HPD Roles

Before importing the data, ensure that all HPD Roles are created. There should be at least these four roles, called HPDEDIT, HPDSELECT, HPDEXECUTE, and one that has the name of your HPD Schema user’s name plus "ADM_R" appended in the end of the name, for example, if your schema is called HPDOWER, there should be a role named HPDOWNERADM_R in the query below:

> sqlplus system/password@database

 

SQL> select role from dba_roles where
     role in ('HPDSELECT', 'HPDEXECUTE', 'HPDEDIT') 
     or role like '%ADM_R';

ROLE
----------------------
HPDEDIT
HPDSELECT
HPDEXECUTE
HPDOWNERADM_R

SQL> exit

If these roles are already in place, for example if you had at some point an HPD schema on this Oracle instance, you can skip to the next step, but if this is the first time you have an HPD schema on the Oracle instance, then use the following steps to create them:

> cd C:\ProgramData\CARIS\HPD\<version>\Server\NewDatabase
> sqlplus system/password@database

-- Create the role using the name of your own HPD schema, in this example
-- the HPD schema is called HPDOWNER:

SQL> CREATE ROLE HPDOWNERADM_R;

-- Create the HPDEDIT, HPDSELECT and HPDEXECUTE roles
-- using the newroles.sql script:

SQL> @newroles

SQL> exit