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:
- Run the script from
$ORACLE_HOME/ora_scriptsfolder. - Switch to aptare user.
su -aptare
- 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