Oracle data collection job fails with error 'ORA-01031: insufficient privileges' in Control Compliance Suite (CCS)
search cancel

Oracle data collection job fails with error 'ORA-01031: insufficient privileges' in Control Compliance Suite (CCS)

book

Article ID: 164026

calendar_today

Updated On:

Products

Control Compliance Suite Databases Oracle Control Compliance Suite Control Compliance Suite Standards Server

Issue/Introduction

Oracle data collection fails with error: ORA-01031: insufficient privileges

Cause

Minimum privileges required for Oracle data collection were missing.

Resolution

Please refer the Symantec Control Compliance Suite Data Collection Privileges Guide, Chapter 3  "Privileges for Oracle"  (attached to this KB).

Note: These are privileges related to predefined Oracle standards. If you have custom standard that includes 'Check' depend on some other entity then it may have to obtain information from different table, Database,Schema,View,etc.. The oracle user mentioned on Oracle data collection should have access to that particular entity for successful data collection.  

Attachments

CCS_Data_Collection_Privileges.pdf get_app
Powered by Wolken Software