Cannot bypass the grant privileges popup when creating a new Oracle database agent (4307290)

Chat now with support

Zurück

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Titel

Cannot bypass the grant privileges popup when creating a new Oracle database agent
Beschreibung

After adding the username and password to grant privileges when creating a new Oracle database agent, the popup does not display an error however the "grant privileges username/password" pop up window reappears and cannot be bypassed.
Ursache

The ValidatePrivileges script fails with an ORA-06550 Error code. The DBO user - user account could execute DBMS_SQL package (built-in PL/SQL package). This user could not see this package and hence the error "PLS-00201: identifier 'DBMS_SQL' must be declared" and this results in ORA-06550 error.
DBMS_SQL is a PUBLIC SYNONYM for the DBMS_SQL package which resides on the "SYS" schema. Either the public synonym has been removed or the EXECUTE permission of DBMS_SQL from the "PUBLIC" schema and therefore the foglight user cannot access it.
Lösung

Execute was granted on the DBMS_SQL package to the database agent user and the grant permissions script could then be run.

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Empfohlener Inhalt

Produkt(e):: Foglight
6.1.0, 6.0.0, 5.9.8, 5.9.7, 5.9.5, 5.9.4, 5.9.3, 5.9.2, 5.7.5, 5.7.1, 5.6.11, 5.6.10, 5.6.7; Foglight for Databases
6.1.0, 6.0.0, 5.9.7, 5.9.5, 5.9.4, 5.9.3, 5.9.2

Titel