Minimum Accesses Needed for IM/GM database service id's?

Products

• CA Identity Manager
• CA Identity Governance
• CA Identity Portal

Issue/Introduction

What is the minimum Accesses Needed for IM/GM database service id's?

Environment

CA identity Manager Virtual App 14.x

Resolution

Oracle: 
The schema user must have the following database roles: 
CONNECT 
RESOURCE 


MS SQL: DBO privilege 

Here is a link to the R14.s documentation on DB installs:

https://techdocs.broadcom.com/us/en/symantec-security-software/identity-security/identity-portal/14-2/installing/installing-ca-identity-portal/ca-identity-portal-installation/installing-a-database.html