DevOps, CI/CD and Automation

Hi All,

CREATE OR REPLACE DIRECTORY ST_XMLDIR AS

'/employees/emp/records';

GRANT EXECUTE, READ, WRITE ON DIRECTORY ST_XMLDIR TO INST1 WITH GRANT OPTION;

I don't have access to create directory in the database .My DBA  created the above directory .

select z.*  

from  xmltable( 

  xmlnamespaces ('urn:org:abcd:message:RBatch:v2.1.0' as "q1"), 

  '//ID' 

  passing xmltype(bfilename('ST_XMLDIR','TRESP.xml'),NLS_CHARSET_ID('AL32UTF8')) 

  columns 

  id varchar2(30) path '.' 

  ,rstatus varchar2(30) path './parent::*/parent::*/parent::*/ResponseStatus' 

) z 

  ;

Oracle database version : Oracle Database 12c - 64bit 

When I am executing above query in the INST1 schema , I am getting below error .

ORA-22288: file or LOB operation FILEOPEN failed

Permission denied

ORA-06512: at "SYS.XMLTYPE", line 296

ORA-06512: at line 1

Please let me know what permissions I should provide to run successfully .

Thanks

sai