One user to query both cdb v$ and pluggable user schema tables

All,

Oracle database 19.8

My monitoring tool (Datadog) allows for only 1 user login to run all its monitor queries.

It needs to run queries against v$ tables in the container as well as against a user table in the pluggable.

I have created a common user c##datadog and granted it :

GRANT CREATE SESSION TO c##datadog CONTAINER=ALL;

This allows c##datadog to login to the container and read v$ information about cdb and pdb like v$session and v$rman_backup_job_details. That works great.

My next problem is that I need c##datadog to query a table from the pluggable user schema WHILE LOGGED INTO THE CONTAINER.