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

Tchater maintenant avec le support

Retour

Commentaire envoyé

Cet article vous a-t-il à résoudre un problème ?

Sélectionner une évaluation

Titre

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

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

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.
Résolution

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

Commentaire envoyé

Cet article vous a-t-il à résoudre un problème ?

Sélectionner une évaluation

Contenu recommandé

Produit(s) :: 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

Historique de l’article :: Créé le : 7/22/2016
Dernière mise à jour le : 5/7/2023

Titre