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

Home -> Community -> Mailing Lists -> Oracle-L -> PL/SQL and file's permissions

PL/SQL and file's permissions

From: DEMANCHE Luc (Cetelem) <luc.demanche_at_cetelem.fr>
Date: Fri, 3 Nov 2000 15:49:41 +0100
Message-Id: <10669.121065@fatcity.com>


This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C045A5.51CFA71C
Content-Type: text/plain;

        charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi Gurus,=20
I would like to know if I can change a file's permission in PL/SQL stored procedures.=20
In a stored proc, we created flat files on Unix and they have "oracle" and "oinstall" as the owner and group.=20 Can we change the owner and group on the flat file that I have created in stored procedures?=20

TIA=20

-----------------=20

Luc Demanche=20
CETELEM=20
T=E9l.: 01-46-39-14-49=20
Fax : 01-46-39-59-88=20

------_=_NextPart_001_01C045A5.51CFA71C
Content-Type: text/html;

        charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>

<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2448.0">
<TITLE>PL/SQL and file's permissions</TITLE>
</HEAD>
<BODY>

<P><FONT FACE=3D"Times New Roman">Hi Gurus, </FONT>
<BR><FONT FACE=3D"Times New Roman">I would like to know if I can change =
a file's permission in PL/SQL stored procedures. </FONT>
<BR><FONT FACE=3D"Times New Roman">In a stored proc, we created flat =
files on Unix and they have &quot;oracle&quot; and &quot;oinstall&quot; = as the owner and group. </FONT>
<BR><FONT FACE=3D"Times New Roman">Can we change the owner and group on =
the flat file that I have created in stored procedures? </FONT>
</P>

<P><FONT FACE=3D"Times New Roman">TIA</FONT>
</P>

<P><FONT SIZE=3D2 FACE=3D"Arial">-----------------</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Luc Demanche</FONT>
<BR><B><I><FONT FACE=3D"Arial">CETELEM</FONT></I></B>
<BR><FONT SIZE=3D2 FACE=3D"Arial">T=E9l.: 01-46-39-14-49</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Fax : 01-46-39-59-88</FONT>
</P>

</BODY>
Received on Fri Nov 03 2000 - 08:49:41 CST

Original text of this message

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