To whom it may concern:
I'm working in a 19c Autonomous Database trying to create a user “analyst” to do text and entity extraction of documents. When granting CTXSYS privileges, some work and some fail. From lines 7-14 below, 4 grants succeed and 4 grants fail due to insufficient privileges. Are there changes I need to make to my admin account to enable me to grant the privileges to analyst?
create user analyst identified by XXX default tablespace analyst_ts;
grant create session, create table , create view, create type, create procedure, create sequence to analyst;
grant create job to analyst;
grant ctxapp to analyst;
grant select on V$PARAMETER to analyst;
grant execute on ctx_entity to analyst;
GRANT EXECUTE ON CTXSYS.CTX_CLS to analyst; --failed ora-01031 insufficient privileges
GRANT EXECUTE ON CTXSYS.CTX_DDL to analyst;
GRANT EXECUTE ON CTXSYS.CTX_DOC to analyst; --failed ora-01031 insufficient privileges
GRANT EXECUTE ON CTXSYS.CTX_OUTPUT to analyst;
GRANT EXECUTE ON CTXSYS.CTX_QUERY to analyst; --failed ora-01031 insufficient privileges
GRANT EXECUTE ON CTXSYS.CTX_REPORT to analyst; --failed ora-01031 insufficient privileges
GRANT EXECUTE ON CTXSYS.CTX_THES to analyst;
grant execute on CTXSYS.CTX_ULEXER to analyst;
grant execute on dbms_crypto to analyst;
grant alter session to analyst;