NetBackup IT Analytics Release Notes

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

Reinstate Revoked Public Privileges of Oracle Users

This script reinstates the public privileges of Oracle users that were revoked when the NetBackup 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