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.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .