• 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 pgAdmin and connect to the PostgreSQL Pro server
  2. Open the context menu of the Databases item 
  3. Select Create, Database
  4. Specify a database name, for example: Core, CoreJobs, IdP, IdPJobs, LS
  5. Click Save

Creating a Service Account to Work with Data Storage

  1. Launch pgAdmin and connect to the PostgreSQL Pro server
  2. Open the context menu of the Login/Group Roles item
  3. Select Create, Login/Group Role
  4. Specify a Name, for example IPAMSQLServiceOps
  5. Go to Definition tab, enter the new password for account
  6. Go to Privileges tab, check Yes for Can Login? and Superuser? items
  7. Click Save, repeat for the rest of the databases.

The Superuser for PostgreSQL is required only for the first access to the database.

  • No labels