How to meet credential requirements for Oracle discovery / scan queries

How to meet credential requirements for Oracle discovery / scan queries

Article: 100042257
Last Published: 2019-05-15
Ratings: 0 0
Product(s): Information Map

Description

Oracle user used for discovery and scanning must have the following two privileges to successfully run the discovery/scan queries:

1) CREATE SESSION

2) SELECT ANY DICTIONARY

Here is an example where we provided the necessary privileges to user infomapsvc.

CREATE USER infomapsvc IDENTIFIED BY <password>;
GRANT CREATE SESSION TO infomapsvc;
GRANT SELECT ANY DICTIONARY TO infomapsvc;

 

Was this content helpful?