Skip to Main Content

Cloud Platform

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!

Insufficient privileges to create a data directory in DB associated with JCS-SX

SamrajyamJan 29 2016 — edited Mar 16 2016

Hi

We have JCS-SX trial environment. I guess DB comes with it is Database as a schema Service. I am trying to use external tables in DB associated with JCS-SX.

For this,we need to create a data directory similar to below.

>>> create or replace directory data_dir as '/customer/scratch/test';

But I am getting insufficient privileges error , How do I give  "GRANT create any directory" privilege to my users.?

I need SYS or DBA access to this .  Please suggest.

Thanks in Advance

Samrajyam

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 13 2016
Added on Jan 29 2016
10 comments
2,208 views