Forum OpenACS Q&A: Response to using dbms_job to sync interMedia indeces

Collapse
3: Response to using dbms_job to sync interMedia indeces (response to 1)
Posted by Andrew Grumet on 07/12/02 02:18 PM
Have you tried simply a grant ctxapp to yon;
This doesn't work, because as Yon mentions, dbms_jobs do not inherit privileges granted through roles. "ctxapp" is a role. On the other hand, the needed "execute" privilege can be granted directly: 
connect ctxsys/passwd
grant execute on ctx_ddl to user;