REPLAYSECURITYOPTION

This Essbase configuration setting specifies the user security settings that are used when replaying logged transactions.

Syntax

REPLAYSECURITYOPTION n

n—An integer that specifies the user security setting. Valid values are as follows:

  • 1—(Default) Specifies the security settings of the user who originally performed the transaction. If that user no longer exists or that user's username was changed, the replay operation will fail.

    Oracle does not recommend renaming another user with the name of the original user, as the security settings of the renamed user might not match those of the original user and the transaction might be played with the incorrect security settings.

  • 2—Specifies the security settings of the administrator performing the replay operation.

  • 3—Specifies the security settings of the user who originally performed the transaction. If that user no longer exists or that user's username was changed, the security settings of the administrator performing the replay operation are used.

You must restart Essbase Server to initialize any change to the configuration.

See Also

Alter Database MaxL statement (with replay transactions)

TRANSACTIONLOGLOCATION configuration setting

TRANSACTIONLOGDATALOADARCHIVE configuration setting