ORA-27486: Insufficient Privileges

Question

I'm getting "ORA-27486: Insufficient privileges" error.

What grants am I missing here? I'm executing an insert script using DBMS_PARALLEL_EXECUTE and I'm getting getting this error in DBMS_PARALLEL_EXECUTE.RUN_TASK

Sample script:

INSERT INTO TAB(col2, col2)
SELECT PDPT_PTY.FUNC(col1), col2
FROM TAB_PRT

I'm able to execute if I don't use PDPT_PTY.FUNC(),I mean if I just use 'col1'.

I've tried giving the grants for DBMS_PARALLEL_EXECUTE on all the users including PDPT_PTY.

Lajos Arpad · Accepted Answer · 2024-11-23 18:53:53Z

0

To execute chunks in parallel, you must have CREATE JOB system privilege.

Source: 123.2 from the docs.

Besides this of course you will need INSERT privilege on TAB as well as SELECT privilege on TAB_PRT.

However, given the fact that your execution fails only due to the function call, you will need the EXECUTE privilege for PDPT_PTY, see https://docs.oracle.com/cd/A58617_01/server.804/a58227/ch18.htm

answered Nov 23, 2024 at 18:53

Lajos Arpad

80.4k42 gold badges122 silver badges234 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ranjan Dec 14, 2024 at 4:04

Thank you! Getting the grant on CREATE JOB and DBMS_SCHEDULER did the work.

Collectives™ on Stack Overflow

ORA-27486: Insufficient Privileges

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related