• Created by Unknown User (anastasia.antonenko), last modified on May 16, 2024

Databases in Use

Axidian Privilege uses Microsoft SQL Server or PostgreSQL Pro to store data. The following components require databases:

  • Core — Axidian Privilege Core component database is used to store Axidian Privilege privileged accounts, resources, permissions, and other service data
  • CoreJobs — Axidian Privilege Core component database is used to store scheduled jobs
  • Idp — IdP component database is used to store authenticators of Axidian Privilege users and administrators
  • IdpJobs — IdP component database is used to store scheduled jobs
  • LS — Log Server component database is used to store the Axidian Privilege events

Database Creation

  1. Launch Microsoft SQL Management Studio (SSMS) and connect to Microsoft SQL Server instance
  2. Open the context menu of Databases item
  3. Select the New Database item
  4. Specify a database name, for example Core, CoreJobs, IdP, IdpJobs, LS
  5. Click ОK

Creating a Service Account to Work with Data Storage

  1. Start Microsoft SQL Management Studio (SSMS) and connect to the Microsoft SQL Server instance
  2. Expand the Security item
  3. Open the context menu of Logins item
  4. Select the Create login item
  5. Enter the name, for example IPAMSQLServiceOps
  6. Select SQL Server authentication item and fill in the required fields
  7. Switch to User Mapping item
  8. Check Core, CoreJobs, IdP, IdPJobs and LS databases
  9. Check database roles db_owner, db_datareader and db_datawriter
  10. Click ОK

The grants db_owner for Microsoft SQL Server is required only for the first access to the database.

A certificate for the MSSQL instance is required for Axidian Privilege.

  • No labels