For installation and operation of a One Identity Manager database, the following database server and database settings are required:
Table 8: Database server settings
Language |
English |
|
Server Collation |
Case insensitive
SQL_Latin1_General_CP1_CI_AS (recommended) |
|
Extreme transaction processing supported (Is XTP supported) |
True |
Default setting. |
SQL Server Agent |
Started |
Default setting. |
Table 9: Database settings
Collation |
SQL_Latin1_General_CP1_CI_AS |
The setting is checked by the Configuration Wizard before installing or updating the One Identity Manager database and adjusted for the database if necessary. |
Recovery model |
Full |
Default setting. |
Compatibility level |
SQL Server 2016 (130) |
The setting is checked by the Configuration Wizard before installing or updating the One Identity Manager database and adjusted for the database if necessary. |
Auto Create Statistics |
True |
The setting is checked by the Configuration Wizard before installing or updating the One Identity Manager database and adjusted for the database if necessary. |
Auto Update Statistics |
True |
The setting is checked by the Configuration Wizard before installing or updating the One Identity Manager database and adjusted for the database if necessary. |
Auto Update Statistics Asynchronously |
True |
The setting is checked by the Configuration Wizard before installing or updating the One Identity Manager database and adjusted for the database if necessary. |
Arithmetic Abort enabled |
True |
The setting is checked by the Configuration Wizard before installing or updating the One Identity Manager database and adjusted for the database if necessary. |
Quoted Identifiers Enabled |
True |
The setting is checked by the Configuration Wizard before installing or updating the One Identity Manager database and adjusted for the database if necessary. |
Broker Enabled |
True |
The setting is checked by the Configuration Wizard before installing or updating the One Identity Manager database and adjusted for the database if necessary. |
Is Read Committed Snapshot On |
True |
The default setting for transactions is AutoCommit. If transactions are required, they are opened explicitly.
These settings have proven to provide the best balance between data security and performance for One Identity Manager's massive parallel processing. Other transaction modes are not supported by One Identity Manager.
The setting is checked by the Configuration Wizard before installing or updating the One Identity Manager database and adjusted for the database if necessary. |
Parameterization |
Forced |
The setting is checked by the Configuration Wizard before installing or updating the One Identity Manager database and adjusted for the database if necessary. |
Database file and date file group for memory-optimized tables |
Required |
Default setting. |
The following users are identified for using a One Identity Manager database in a managed instance in the Azure SQL Database with the granular permissions concept. User permissions at server and database level are matched to their tasks.
- Installation user
The installation user is needed for the initial installation of a One Identity Manager database using the Configuration Wizard.
- Administrative user
The administrative user is used by One Identity Manager components that require permissions at server and database level, including for example the Configuration Wizard, DBQueue Processor, or the One Identity Manager Service.
- Configuration user
The configuration user can execute configuration tasks within One Identity Manager, for example, creating customer-specific schema extensions or working with the Designer. Configuration users need permissions at the server and database levels.
- End user
End users are only assigned permissions at database level in order, for example, to complete tasks with the Manager or the Web Portal.
Permissions for installation users
A SQL Server login and a database user with the following permissions must be provided for the installation user.
SQL Server:
-
Member of dbcreator server role
The server role is only required if the database is created using the Configuration Wizard.
-
Member of securityadmin server role
This server role is required to create SQL Server logins.
-
view server state permissions with the with grant option option and alter any connection permissions with the with grant option option.
The permissions are required to check connections and close these if necessary.
-
alter any server role permissions
The permissions are required to create the server role for the administrative user.
msdb database:
-
Select permissions with the with grant option option for the dbo.sysjobs, sysjobsteps, dbo.sysjobschedules, dbo.sysjobactivity, and dbo.sysschedules tables
The permissions are required to execute and monitor database schedules.
-
alter any user permissions
The permissions are required to create the necessary database users for the administrative user.
-
alter any role permissions
This permission is required to create the necessary database role for the administrative user.
master database:
-
alter any user permissions
The permissions are required to create the necessary database users for the administrative user.
-
alter any role permissions
This permission is required to create the necessary database role for the administrative user.
-
Execute permissions with the with grant option option for the xp_readerrorlog procedure
The permissions are required to find out information about the database server's system status.
-
Execute permissions with the with grant option option for the xp_sqlagent_is_starting, xp_sqlagent_notify, and xp_sqlagent_enum_jobs procedures
The permissions are required to execute and monitor database schedules.
One Identity Manager database:
-
Member of the db_owner database role
This database role is only required if you wish to use an existing database or a schema update is performed when installing the schema with the Configuration Wizard.
Permissions for administrative users
During the installation of the One Identity Manager database using the Configuration Wizard, the following principal elements and permissions are created for the administrative user:
SQL Server:
msdb database:
- OneIMRole_<DatabaseName> database role
-
Member of the SQLAgentUserRole database role
The database role is required to execute database schedules.
-
Select permissions for the dbo.sysjobs,sysjobsteps, dbo.sysjobschedules, dbo.sysjobactivity, and dbo.sysschedules tables
The permissions are required to execute and monitor database schedules.
- OneIM_<DatabaseName> database user
master database:
One Identity Manager database:
-
Admin database user
-
Member in db_owner database role
The database role is required to update a database with the Configuration Wizard.
-
The database user is assigned to the <DatabaseName>_Admin SQL server login.
Permissions for configuration users
During the installation of the One Identity Manager database using the Configuration Wizard, the following principal elements and permissions are created for configuration users:
SQL Server:
One Identity Manager database:
Permissions for end users
The following principals are created with the permissions for end users during the installation of the One Identity Manager database with the Configuration Wizard:
SQL Server:
One Identity Manager database:
One Identity Manager administration and configuration tools are installed on an administrative workstation in order to edit and display data.
The following system prerequisites must be guaranteed for installing tools on an administrative workstation.
Table 10: Minimum system requirements - administrative workstations
Processor |
4 physical cores 2 GHz+ |
Memory |
4 GB+ RAM |
Hard drive storage |
1 GB |
Operating system |
Windows operating systems
Following versions are supported:
- Windows 10 (32-bit or 64-bit) minimum version 1511
- Windows 8.1 (32-bit or 64-bit) with the current Service Pack
- Windows 7 (32-bit or non-Itanium 64-bit) with the current service pack
|
Additional software |
|
Supported browsers |
- Internet Explorer 11 or later
- Firefox (Release Channel)
- Chrome (Release Channel)
- Microsoft Edge (Release Channel)
|
The One Identity Manager Service enables the distribution of the information that is administrated in the One Identity Manager database throughout the network. The One Identity Manager Service performs data synchronization between the database and any connected target systems and executes actions at the database and file level.
The following system prerequisites must be fulfilled to install the One Identity Manager Service on a server.
Table 11: Minimum system requirements - services server
Processor |
8 physical cores 2.5 GHz+ |
Memory |
16 GB RAM |
Hard drive storage |
40 GB |
Operating system |
Windows operating systems
The following versions are supported:
Linux operating systems
- Linux operating system (64-bit), supported by the Mono project, or Docker images provided by the Mono project.
|
Additional software |
Windows operating systems
Linux operating systems
|
Related topics