My team has found that to execute an Oracle stored procedure from WMB V7, the connecting userid needs read privileges to several oracle catalog tables/views, such as sys.dba_objects, but we couldn't find any reference to the exact list of privileges we needs in WMB manuals.
Do you know which privileges are needed?
Our DBA is reluctant to grant those permissions. Does giving read privilege on sys.dba_objects expose us to some security risk?
Thank you so much.