Hi,=20
the only solution i know is to use in the init.ora the full name of
the directory you want to allow read/write.
utl_file_dir =3D /directory/users
utl_file_dir =3D /directory/users/user1
utl_file_dir =3D /directory/users/user2
utl_file_dir =3D /directory/users/user3
..
repeat as necessary
=09
May be others solutions can be realised by using a pl/sql calling a
PRO*C or C program ?
Regards
PHD
> -----Message d'origine-----
> De: Baylis, John [SMTP:JBaylis_at_mail.canfor.ca]
> Date: mercredi 18 octobre 2000 10:26
> =C0: Multiple recipients of list ORACLE-L
> Objet: utl_file_dir parameter
>=20
> We would like to create files in various directories on HP unix using =
the
> utl_file package=20
>=20
> Since what we really need is=20
>=20
> utl_file_dir =3D /directory/users/* which does =
not
> work,=20
>=20
>=20
> and we do not want to specify the following due to security =
reasons,
> is there any alternative methods that are available to accomplish =
this?
>=20
> utl_file_dir =3D *=20
>=20
> Are there other techniques or work arounds?=20
>=20
> John Baylis=20
> DBA / Systems Administrator=20
> Canadian Forest Products Ltd.=20
Received on Tue Oct 17 2000 - 18:06:28 CDT
