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

Chatta subito con l'assistenza

Restituisci

Feedback inviato

Questo articolo ti è servito per risolvere il problema?

Seleziona valutazione

Titolo

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

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.
Causa

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.
Risoluzione

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

Feedback inviato

Questo articolo ti è servito per risolvere il problema?

Seleziona valutazione

Contenuti consigliati

Prodotto/i:: 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

Cronologia articoli:: Data di creazione: 7/22/2016
Ultimo aggiornamento: 5/7/2023

Titolo