search cancel

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


Article ID: 164026


Updated On:


Control Compliance Suite Databases Oracle Control Compliance Suite Control Compliance Suite Windows Control Compliance Suite Unix Control Compliance Suite Standards Server


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


Minimum privileges required for Oracle data collection were missing.


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

Using the same guide, a script has been created that creates an Oracle database user that has all the necessary rights as outlined. It will make it easier for the Oracle DBA to create the correct user with the correct privileges. Adjust the username and password as needed in the attached  'create_oracle_user_for_ccs_data-collection_ccs_user.SQL.txt'  script.

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.  


create_oracle_user_for_ccs_data-collection_ccs_user.SQL.TXT get_app
CCS_Data_Collection_Privileges.pdf get_app