Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Databases names are fixed due to names on the Configuration Files Setup page.

Databases in Use

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

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

Database Creation

Divbox
stylebackground:#FAFAFA


Expand
titlePostgreSQL, PostgreSQL Pro
  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: IPAMCoreCore,  IPAMCoreJobs CoreJobs,  IPAMIdPIdP, IPAMIdPJobs IdPJobs, ILS
  5. Click Save


Creating a Service Account to Work with Data Storage

Divbox
stylebackground:#FAFAFA


Expand
titlePostgreSQL, PostgreSQL Pro
  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.



Note
iconfalse

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



Divbox
classrightFloat

Table of Contents
printablefalse