Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

How to find the udump directory (SQL)

82 views
Skip to first unread message

James

unread,
Mar 6, 2003, 3:02:35 PM3/6/03
to
Hi there
Does anyone know how to find the value of the "USER_DUMP_DEST" of the
initialisation file using sql? This directory is the udump directory on the
server.

Thanks in Advance
James


Gabriel Gonzalez

unread,
Mar 6, 2003, 3:10:34 PM3/6/03
to
> Does anyone know how to find the value of the "USER_DUMP_DEST" of the
> initialisation file using sql? This directory is the udump directory on
the
> server.

select value from v$system_parameter where name='user_dump_dest';

I think you need to be logged in as sys or system... Or with DBA privs,
something like that


James

unread,
Mar 6, 2003, 3:27:25 PM3/6/03
to
Thanks very much!

"Gabriel Gonzalez" <no-...@no-spam.com> wrote in message
news:7oGcnTKpA7A...@giganews.com...

Sybrand Bakker

unread,
Mar 6, 2003, 3:29:00 PM3/6/03
to
On Thu, 6 Mar 2003 12:10:34 -0800, "Gabriel Gonzalez"
<no-...@no-spam.com> wrote:

>select value from v$system_parameter where name='user_dump_dest';
>
>I think you need to be logged in as sys or system... Or with DBA privs,
>something like that
>


The SELECT_CATALOG_ROLE is sufficient.


Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address

Gabriel Gonzalez

unread,
Mar 6, 2003, 3:48:42 PM3/6/03
to
> The SELECT_CATALOG_ROLE is sufficient.

Ah, thanks... The last time I did this I was in a big hurry, and paid no
attention.


Tanel Poder

unread,
Mar 6, 2003, 4:04:04 PM3/6/03
to
A small note:

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.


"Gabriel Gonzalez" <no-...@no-spam.com> wrote in message

news:VtWdnRZO8JL...@giganews.com...

Sybrand Bakker

unread,
Mar 6, 2003, 5:00:19 PM3/6/03
to
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.

Tanel Poder

unread,
Mar 6, 2003, 5:26:30 PM3/6/03
to
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.

0 new messages