Home
The Toolkit for Online Communities
15902 Community Members, 0 members online, 2410 visitors today
Log In Register

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

OpenACS Home : Forums : OpenACS Q&A : Response to using dbms_job to sync interMedia indeces : One Message

+
Posted by Andrew Grumet on
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;