Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ORA-01749

874273Dec 25 2016 — edited Dec 25 2016

Hi Masters,

I am getting error. Please advise.

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production

With the Partitioning, OLAP and Data Mining options

SQL> create or replace directory DATA_PUMP_DIR_1 as 'dr/exp/DataPump/';

Directory created.

SQL> grant read,write on directory data_pump_dir_1 to sys;

grant read,write on directory data_pump_dir_1 to sys

                                                 *

ERROR at line 1:

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

Regards

AR
This post has been answered by Saubhik on Dec 25 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 22 2017
Added on Dec 25 2016
1 comment
577 views