Re: How to Make User Dumps Readable?

I found the answer in http://www.oreview.com/9604har.htm (but have not yet tried it out). Apparently you can set the 'undocumented parameter' '_TRACE_FILES_PUBLIC' to 'TRUE' in the init.ora file. Oracle does not do this because the trace files could contain Role passwords, sensitive data, or other security items. The syntax would be:

_TRACE_FILES_PUBLIC=TRUE Regards.

>
> Question: How do you tell Oracle to make user dumps readable to either a
> group or the world? By default on our system, they are readable only by
> a privileged Oracle group, but developers need access.
>
> It seems that I read somewhere that there was a setting to do this, but
> I cannot locate that reference now.
>
> Our environment: Oracle 7.3.2.3 on Silicon Graphics Challenge L running
> IRIX 5.3.
>
> TIA.
> +-----------------------------------------------------
> | Dan Townsend, Supervising Database Architect
> | EBMUD Enterprise Object Designer
> | mailto:townsend_at_ebmud.com
> +-----------------------------------------------------
 

-- 
+-----------------------------------------------------
| Dan Townsend, Supervising Database Architect
| EBMUD Enterprise Object Designer
| mailto:townsend_at_ebmud.com
+-----------------------------------------------------