Re: How to find the udump directory (SQL)

From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Thu, 06 Mar 2003 23:00:19 +0100
Message-ID: <l1hf6voge78mg1n3u4mltr4103spi28s19@4ax.com>

On Thu, 6 Mar 2003 23:04:04 +0200, "Tanel Poder" <tanel@@peldik.com> wrote:

>A direct grant to v_$parameter should work as well, if you don't want to
>give the entire select_catalog_role to a user.. having access to v$sqltext
>etc.. views is a potential security hole for example..
>
>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:00:19 CST