Re: Unix file permissions

On 09/20/2006 08:47:30 AM, Derya Oktay wrote:
> Hi Mladen
> You see it works for udump directory. Could you do it for *.trc files in
> bdump directory?
> Thanks.
> Derya.

Yes, of course. You can put _trace_files_public into the parameter file and restart the instance. You can also put a "find" command into the crontab and do chmod on every trace file every few minutes. You could also be very permissive and lax about granting users the dba group (Unix group, not Oracle group). Who needs to access files in bdump and why? Files in udump are frequently needed for performance analysis, but it is beyond me why would anybody who isn't a DBA need to have access to the bdump directory? Actually, the best thing to do is to execute the following: "chmod 777 /etc/passwd". That would allow anybody with a shell account to access all the trace files and some other things, too.

-- 
Mladen Gogala
http://www.mgogala.com

--
http://www.freelists.org/webpage/oracle-l