This section provides configuration options for using an Oracle database for the User Application. For information about supported versions of Oracle, see Section 6.7.6, System Requirements for Installing the User Application and Roles Based Provisioning Module.
Your User Application database must use a Unicode-encoded character set. When creating the database, use AL32UTF8 to specify this character set.
To confirm that an Oracle 11g database is set for UTF-8, issue the following command:
select * from nls_database_parameters;
If the database is not configured for UTF-8, the system responds with the following information:
NLS_CHARACTERSET WE8MSWIN1252
Otherwise, the system responds with the following information that confirms the database is configured for UTF-8:
NLS_CHARACTERSET AL32UTF8
For more information about configuring a character set, see “Choosing an Oracle Database Character Set”.
The User Application requires that the Oracle database user account have CONNECT and RESOURCE privileges. In the SQL Plus utility, enter the following commands:
CREATE USER idmuser IDENTIFIED BY password
GRANT CONNECT, RESOURCE to idmuser
where idmuser represents the user account.