Oracle DB Catalog Discovery Applicative credential Requirement

Abhishek41 · ‎10-11-2023

Hi All,

I want to discover Oracle catalogs for windows and Unix machines. I want to request applicative credential to the Oracle DB team, but I am not sure what permission the discovery user should have to discover DB catalog.

Can somebody share the applicative user privileges/permissions details.

Thanks,

Abby

Rahul Priyadars · ‎10-11-2023

Hi Abhishek

The ServiceNow Discovery application uses the Oracle Catalog discovery pattern to find Oracle Catalog objects.

If possible start with Sys Admin with read only role else we have to open the above Pattern and tell them commands used for it and Its tricky.

Make sure User has read access for below

read access for below

tnsnames.ora file

DBA_FEATURE_USAGE_STATISTICS
CDB_FEATURE_USAGE_STATISTICS
V$DATABASE
V$VERSION
GV$PARAMETER
V$CONTAINERS
V$INSTANCE

Regards

RP

View solution in original post

Rahul Priyadars · ‎10-11-2023