Additional Oracle permissions and TS$ (tablespace) error

Document ID : KB000033552
Last Modified Date : 04/02/2019
Show Technical Document Details
Issue:
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.

 
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$';