Top
Enterprise Postgres 17 Cluster Operation Guide(Database Multiplexing)

E.1 Security Policy Settings

This section explains how to configure the security settings to enable an operating system user account designated as an instance administrator user to log on as a service.

1. Displaying the [Local Security Policy] window

In Windows, select [Administrative Tools], and then click [Local Security Policy].

2. Setting up security
  1. In the [Local Security Policy] window, select [Security Settings], select [Local Policies], and then click [User Rights Assignment].

  2. Under [Policy] in the [User Rights Assignment] window, double-click [Log on as a service].

  3. In the [Log on as a service Properties] window, set the following:

    1. Select the [Local Security Setting] tab.

    2. On the [Local Security Setting] tab, click [Add User or Group].

    3. In the [Select Users or Groups] window, enter the operating system user account of the instance administrator user in [Enter the object names to select].

    4. Click [OK].

  4. In the [Log on as a service Properties] window, click [OK].

  5. From the [Local Security Policy] tree, click [Local Policies], and then double-click [Security Options].

  6. Scroll down and double-click [User Account Control: Behavior of the elevation prompt for administrators in Admin Approval Mode].

  7. From the drop-down menu, select the "Elevate without prompting" in the [Local Security Setting] tab.

  8. Click [OK].