After restarting DLO services, DLO Databases in an SQL cluster, do not retain the correct Stored Procedures permissions

book

Article ID: 100048502

calendar_today

Updated On:

Description

Error Message

The DLODiagnostics scan will report the following errors;

Following Extended Stored Procedures doesn’t have required permission: sp_shadow_check_maintsvc sp_shadow_derive_public_key

 

Cause

In an SQL Cluster environment, the DLO DBs are detached and reattached as the DLO services are restarted or nodes failover. The permissions are reapplied by DLO during the reattach, overwriting previously correct permissions.

 

Resolution

A supported hotfix has been made available for this issue in the versions mentioned below. Please contact Veritas Technical Support to obtain this fix. This hotfix has not yet gone through any extensive Q&A testing. Consequently, if you are not adversely affected by this problem and have a satisfactory temporary workaround in place, we recommend that you wait for the public release of this hotfix.

This issue is currently being considered by Veritas Technologies LLC to be addressed in the next major revision of the product. Please note that Veritas Technologies LLC reserves the right to remove any fix from the targeted release if it does not pass quality assurance tests or introduces new risks to overall code stability.  Veritas’ plans are subject to change and any action taken by you based on the above information or your reliance upon the above information is made at your own risk.

 

Patch is available for DLO Versions :  9.3.3 and 9.4

Issue/Introduction

If using an SQL cluster with DLO*, when a restart of DLO services occurs, permissions on some Extended Stored Procedures in the Master DB, are not retained. * SQL Clusters are not supported with DLO 9.4 or earlier versions

Additional Information

ETrack: 4014993 JIRA: DLO-3408