1

When I execute this command it won't work. Why am I getting this error? What can I do to fix this? Thanks!

$ grant read,write on directory <SID>_DATA_PUMP_DIR to system;
$ grant read,write on directory <SID>_DATA_PUMP_DIR to system
                                                        *
ERROR at line 1:
ORA-01749: you may not GRANT/REVOKE privileges to/from yourself
3
  • Database Administrators - Stack Exchange is more suitable for your question.
    – Akina
    Oct 24, 2019 at 8:42
  • Hmmm, @Akina, that site advertises it "is for those needing expert answers to advanced database-related questions" (emphasis mine). But it's surely off-topic here indeed.
    – Arjan
    Oct 24, 2019 at 9:18
  • Are you logged in to SQL*Plus as the system user? if not, try to switch to it using conn command.
    – Akina
    Oct 24, 2019 at 9:24

1 Answer 1

1

I think error itself explains it. You have created the DBA_DIRECTORY using system user and trying to provide a grant to itself(Owner).

ORA-01749: you may not GRANT/REVOKE privileges to/from yourself

I think there is no need to run grant command.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.