Oracle Text (MOSC)

MOSC Banner

Oracle text views (ctxsys) are not accessible by SELECT_CATALOG_ROLE

in Oracle Text (MOSC) 2 commentsAnswered

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center