Additional Oracle permissions and TS$ (tablespace) error

book

Article ID: 33552

calendar_today

Updated On:

Products

DX Infrastructure Management NIMSOFT PROBES

Issue/Introduction

In some situations, granting all the permissions specified for the Oracle probe documentation aren't sufficient and a TS$(tablespace) error is thrown when you 'test connection' of an Oracle probe database profile.

 

Environment

Release:
Component: CAUIM

Resolution

These additional permissions allowed for full functionality and the error to disappear.

GRANT SELECT ON "SYS"."GV_$SORT_SEGMENT" TO "NIMSOFT";
GRANT SELECT ON "SYS"."DBA_TABLESPACES" TO "NIMSOFT";

as well as..

SELECT_CATALOG_ROLE','gv_$sort_segment' and 'sys.ts$';