Saviynt Forums

phebewaterfield · ‎03/04/2024

Where can I find the documentation of the connectors that tells me what permissions are needed for the account for the connection?

thank you

Dhruv_S · ‎03/04/2024

Hi @phebewaterfield

Could you please confirm the name of the connector for which you are looking for the above information. You can refer to the documentation of the respective connector.

Please refer to the below posts with similar requirements.

Minimum permissions required for Active Directory ... - Saviynt Forums - 9179

Service Account for ADSI Connector - Minimum privi... - Saviynt Forums - 36746

Regards,

Dhruv Sharma

phebewaterfield · ‎03/05/2024

Thank you Dhruv, I am looking for PeopleSoft specifically.

Dhruv_S · ‎03/05/2024

Hi @phebewaterfield

Please refer to the below section in Connector guide for PeopleSoft connector.

https://docs.saviyntcloud.com/bundle/PeopleSoft-v2021x/page/Content/Introduction.htm

Data Reconciliation

Permission Requirements for Reconciliation

Reconciliation is performed via the EIC service account. This account must have the SELECT permission on the following tables in the PeopleSoft database (or alternatively a staging database) to import all user accounts and the associated fine-grained level accesses.

Table Table Description

PSCLASSDEFN	Permission List header table
PSAUTHITEM	Menu items granted security by permission lists
PSROLEDEFN	Role header table
PSROLECLASS	Permission Lists in roles
PSOPRDEFN	User ID header table
PSROLEUSER	Roles granted to users
PSAUTHBUSCOMP	Access to Component Interfaces
PSAUTHWEBLIBVW	Access to just Web Libraries
PS_SCRTY_ACC_GRP	Query Security Access Groups
PSOPROBJ	Definition security (connects a permission list to a definition group)

Working with the Database Connector

For detailed information about creating a Database connection, see the Database Connector Guide.