Oracle text views (ctxsys) are not accessible by SELECT_CATALOG_ROLE
Oracle 19
The following query shows which views are not accessible publicly or by SELECT_CATALOG_ROLE:
select * from dba_views V
where owner = 'CTXSYS'
AND NOT EXISTS ( SELECT 1 FROM DBA_TAB_PRIVS TP
WHERE TP.OWNER = V.OWNER
AND TP.TABLE_NAME = V.VIEW_NAME
AND TP.PRIVILEGE ='READ'
)
This is the result :
VIEW_NAME
----------
CTX_ALEXER_DICTS
CTX_AUTO_OPTIMIZE_INDEXES
CTX_AUTO_OPTIMIZE_STATUS
CTX_EXTRACT_POLICIES
CTX_EXTRACT_POLICY_VALUES
CTX_FILTER_BY_COLUMNS
CTX_INDEXES
CTX_INDEX_ERRORS
CTX_INDEX_OBJECTS
CTX_INDEX_PARTITIONS
CTX_INDEX_SUB_LEXERS
CTX_INDEX_SUB_LEXER_VALUES
CTX_INDEX_VALUES