Home -> Usenet -> comp.databases.oracle -> RE: Delete UNIX files/tblsp owned by Oracle

RE: Delete UNIX files/tblsp owned by Oracle

From: Gary Gapinski <gapinski_at_lerc.nasa.gov>
Date: 1995/05/12
Message-ID: <3ovi7q$stb_at_sulawesi.lerc.nasa.gov>#1/1 







Place the data files that you allow users to delete in a directory whose
owner is the oracle account and whose group includes those users allowed 
to create and delete files. chmod g+rwx the directory. The files will be
owned by the oracle account but will be deletable by members of the group.
Note that they are not coerced into dropping the tablespace before they 
can delete associated data files. Use as many such directories as there
are distinct groups.



BTW, if you're allowing users to drop tablespaces, perhaps they will be
astute enough to manipulate the initSID.ora file, but, if not, place
that file elsewhere.
Received on Fri May 12 1995 - 00:00:00 CEST












Original text of this message