Re: Unix file permissions

  • From: Mladen Gogala <mgogala@xxxxxxxxxxx>
  • To: oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 20 Sep 2006 20:48:32 -0400

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


Other related posts: