Important Update: Cohesity Products Documentation

All Cohesity product documentation are now managed via the Cohesity Docs Portal: https://docs.cohesity.com/HomePage/Content/home.htm. Some documentation available here may not reflect the latest information or may no longer be accessible.

IT Analytics Release Notes

Last Published:
Product(s): NetBackup IT Analytics (11.7)

Reinstate Revoked Public Privileges of Oracle Users

This script reinstates the public privileges of Oracle users that were revoked when the IT Analytics Portal was either installed or upgraded.

To reinstate the public privileges:

  1. Run the script from $ORACLE_HOME/ora_scripts folder.
  2. Switch to aptare user.
    su -aptare
  3. Reinstate the privileges as directed below.
    cd /opt/aptare/database/ora_scripts

    or

    $ORACLE_HOME/ora_scripts
    sqlplus / as sysdba
	alter session set container=scdb
	
	@  grant_public_role_grants.sql

Granting PUBLIC role grants
Disconnected from Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production
Version 19.26.0.0.0