Re: is it possible to set user_dump_dest at session level?

Life Learner wrote:
> Developers are using tkprof with Oracle 8.1.7 on Solaris, udump are
> only open to oracle user by default, ( I know it can be altered by
> setting _trace_files_public in init.ora ), and they dont have
> sufficient privilege to use 'alter system set user_dump_dest'. I
> wonder is there a way without bothering DBA?

no. (you cannot alter udump at session level)

SELECT name, isses_modifiable
FROM v$parameter a
WHERE name LIKE 'user%'

One reason is that there is a very serious security risk when you allow "anyone" to access to user_dump_dest. Im not telling you what or how to exploit it.

Personally i think its ok to grant access in development and test db but never (we are in "never never land" now ) in production.

Janne! Received on Fri Nov 28 2003 - 14:41:32 CST