Missing Grant Permissions for sys.v_$diag_alert_ext in grant_permissions.sql

[4Aiur]

Problem:

In alertlog.go

oracle-db-appdev-monitoring/alertlog/alertlog.go

Line 108 in 3f08a60

from v$diag_alert_ext

the application attempts to execute SELECT against SYS.V_$DIAG_ALERT_EXT.

However, the docker-compose/oracle/grant_permissions.sql script does not include the necessary GRANT SELECT statement for the pdbadmin user to access this view.

oracle-db-appdev-monitoring/docker-compose/oracle/grant_permissions.sql

Line 11 in 3f08a60

grant select on sys.aq$_queue_shards to pdbadmin;

This discrepancy results in three error occurrences upon docker-compose startup, as the application lacks the required permissions to query the view.

oracle-db-appdev-monitoring/alertlog/alertlog.go

Line 29 in 3f08a60

logger.Info("Failed to query the alert log three consecutive times, so will not try any more")

Steps to Reproduce:

1. docker compose up
2. Observe the application logs for errors related to querying SYS.V_$DIAG_ALERT_EXT.

observability-exporter  | time=2025-04-02T00:45:35.414Z level=INFO source=alertlog.go:40 msg="Log destination file does not exist, will try to create it: /log/alert.log"
observability-exporter  | time=2025-04-02T00:45:35.577Z level=ERROR source=alertlog.go:113 msg="Error querying the alert logs" !BADKEY="dpiStmt_execute: ORA-00942: table or view \"SYS\".\"V_$DIAG_ALERT_EXT\" does not exist"
observability-exporter  | time=2025-04-02T00:45:50.416Z level=ERROR source=alertlog.go:113 msg="Error querying the alert logs" !BADKEY="dpiStmt_execute: ORA-00942: table or view \"SYS\".\"V_$DIAG_ALERT_EXT\" does not exist"
observability-exporter  | time=2025-04-02T00:46:05.415Z level=ERROR source=alertlog.go:113 msg="Error querying the alert logs" !BADKEY="dpiStmt_execute: ORA-00942: table or view \"SYS\".\"V_$DIAG_ALERT_EXT\" does not exist"
observability-exporter  | time=2025-04-02T00:46:20.413Z level=INFO source=alertlog.go:29 msg="Failed to query the alert log three consecutive times, so will not try any more"

Expected Behavior:

The grant_permissions.sql script should include the following SQL statement to grant the pdbadmin user the necessary permissions:

grant select on sys.v_$diag_alert_ext TO pdbadmin;