setting grant for user on CTXSYS.CTX_DLL

[nyck]

Hello,

I have to set grant for user on CTXSYS.CTX_DDL for bugzilla. Generally speaking it seems that I need to have access to
CTX tables such as CTXSYS.CTX_PREFERENCES but user arbor does not see them. How do I go about doing this?

 

[LKBrwnDBA]

Login as CTXSYS and do the grant(s)!



----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[nyck]

So once logged in as CTXSYS is it just a case of doing the following:-

grant execute on ctxsys.ctx_ddl to public

As you can tell from my questions I'm not a dba:-(

 

[Dagon]

Is ctxsys.ctx_ddl a stored proc ? It will be execute if it's a stored proc; otherwise, it will be select, (update, insert, delete).

 

[LKBrwnDBA]

GRANT EXECUTE ON CTXSYS.CTX_DDL TO PUBLIC;

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[nyck]

Still having no luck with this, there is no CTXSYS user within this database and someone mentioned I need to load the context module, how do I go about doing this?

 

[KenCunningham]

So who installed the Oracle Text stuff? This might help understand what's involved:

http://download.oracle.com/docs/cd/B10501_01/text.920/a96517/admin.htm

Some days are diamonds, some days are rocks - make sure most are the former.