4 Replies Latest reply: Mar 15, 2013 3:38 PM by Pschwart-Oracle RSS

    datapump through grid control 12C

    Kunal Narkhede
      hi,

      I have created a schema in database which has exp_full_database privilege to run datapump jobs (verified by running a datapump API job too). I have a os user(non dba group) which has ability to run expdp command.

      I also created an administrator in grid 12C which has connect to target privilege on database target and execute any command privilege on host. However when I submit a datapump job using these credentails, the submission of job fails with error message as "user doesn't have privilege for this operation".

      I am able to execute datapump API successfully from within database schema; using the on dba group os user, I am able to execute expdp command too successfully..

      What am i missing? please help.