Oracle Database Discussions

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!

Getting ora-00990 while giving Grant create directory privilege

Boopathy VasagamMay 31 2010 — edited May 31 2010

Hi,
I need to create a directory (ext_dir_src) in the user 'new_user'.So i have given,
create or replace directory ext_dir_src as '/mark_data/erp/src;

but i was getting an error as:
ORA-01031 insufficient privileges

so i logged in as 'SYSTEM' user and given:
grant create directory to new_user;

but i am getting the following error:
ORA-00990 missing or invalid privileges

Can this privilege be given to 'new_user' from SYSTEM user?
Or my Grant command is wrong?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 28 2010

Added on May 31 2010

#error, #general-database-discussions, #oracle

5 comments

1,958 views