Ransomware attackers specifically target and attempt to destroy backup systems to increase the probability of payment. Hardening your system is critical. Please ensure you have reviewed your platform security using the Security Hardening Checklist
Cohesity

COHESITY Documentation

Explore our documentation to get started, discover products & new features, access troubleshooting guides, register sources, platforms support.

Products
Data Security Alliance
Visit Cohesity.com
Demos
Support
Blogs
Developers
Partner Portals
Cohesity Community
© 2026 Cohesity, Inc. All Rights Reserved.
Terms of Use|
Privacy Policy|
Legal|
  1. Home
  2. IT Analytics Release Notes
  3. Installations and Upgrades
  4. Reinstate Revoked Public Privileges of Oracle Users
IT Analytics Release Notes

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

Feedback

Was this page helpful?
Previous

Performance Profiles and Transmitted Data

Next

Fixed Issues

Feedback

Was this page helpful?