Axidian Privilege uses Microsoft SQL Server or PostgreSQL Pro to store data. The following components require databases:
IPAMCore — Axidian Privilege Core component database is used to store Axidian Privilege privileged accounts, resources, permissions, and other service data
IPAMCoreJobs — Axidian Privilege Core component database is used to store scheduled jobs
IPAMIdp — IdP component database is used to store authenticators of Axidian Privilege users and administrators
IPAMIdpJobs — IdP component database is used to store scheduled jobs
ILS — Log Server component database is used to store the Axidian Privilege events
Database Creation
LaunchpgAdminand connect to the PostgreSQL Pro server
Open the context menu of the Databases item
SelectCreate,Database
Specify a database name, for example:IPAMCore, IPAMCoreJobs, IPAMIdP, IPAMIdPJobs, ILS
ClickSave
Creating a Service Account to Work with Data Storage
LaunchpgAdminand connect to the PostgreSQL Pro server
Open the context menu of theLogin/Group Rolesitem
Select Create,Login/Group Role
Specify aName, for example IPAMSQLServiceOps
Go to Definitiontab, enter the new password for account
Go to Privilegestab, checkYesforCan Login?andSuperuser?items
ClickSave, repeat for the rest of the databases.
TheSuperuserfor PostgreSQL is required only for the first access to the database.