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

Document ID : KB000100221
Last Modified Date : 12/06/2018
Show Technical Document Details
Question:
What is the minimum Accesses Needed for IM/GM database service id's?
Environment:
CA identity Manager Virtual App 14.x
Answer:
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://docops.ca.com/ca-identity-portal/14-2/en/installing/installing-ca-identity-portal/ca-identity-portal-installation/installing-a-database