Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Creating physical opertaing system directory with Oracle

Re: Creating physical opertaing system directory with Oracle

From: Pete Finnigan <plsql_at_petefinnigan.com>
Date: Tue, 4 Nov 2003 11:14:14 +0000
Message-ID: <EG+Rp3AGo4p$Qxke@peterfinnigan.demon.co.uk>


Hi Pinaki,

You could use a java stored procedure or a C external procedure and then call either from PL/SQL. There are many security risks with this though - you should avoid exposing operating system commands to PL/SQL or SQL as this can be exploited especially if your database is accessible remotely. There are many papers about security and Oracle on my website http://www.petefinnigan.com/orasec.htm.

Kind regards

Pete

In article <96eccafc.0311040116.4481cc36_at_posting.google.com>, Pinaki <bpinaki123_at_indiatimes.com> writes
>Hi,
> Is there any way through packages or anything that I can create
>physical operating system directory at a specified path.Suppose, I
>want to create a directory(physical not logical) "ABC" at a specified
>path(D:\Personal\ABC). How can this be done through PL/SQL.
>
>Thanks in advance
>
>Pinaki

-- 
Pete Finnigan
email:pete_at_petefinnigan.com
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for details.
Received on Tue Nov 04 2003 - 05:14:14 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US