Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to find the udump directory (SQL)

Re: How to find the udump directory (SQL)

From: Tanel Poder <tanel_at_@peldik.com>
Date: Fri, 7 Mar 2003 00:26:30 +0200
Message-ID: <3e67ca65$1_2@news.estpak.ee>


Yep, I agree with you. Though from security standpoint, this "unknown" set of v$ views granted to "unknown" individuals can easily be retreived from dictionary.

But, yes, we are lucky if people even change the system & sys password. For example, even I don't always do it :|

Tanel.

> >Tanel.
>
> A direct grant to v_$parameter will be LOST upon export, because SYS
> isn't exported. It will consequently create an administration
> nightmare, and I would consider unknown individuals having access
> directly to an unknown set of v$ views definitely MUCH MORE of a
> security loophole compared to using the SELECT_CATALOG_ROLE.
>
> Anyway, you're nitpicking: most 3rd party sw, developed by juniors,
> grants the DBA role by design to every individual user, and forgets to
> assign an appropiate password to those users.
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Thu Mar 06 2003 - 16:26:30 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US