Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to find the udump directory (SQL)
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