Re: My DBA

In article <db479d88.0206140503.428eead0_at_posting.google.com>,  Charlie3101_at_hotmail.com (Charlie Edwards) wrote:

> I have just received the following from my DBA:
>
> "ALTER SESSION has been granted to your account. This privilege is
> granted on the basis that it will be used to switch on PLSQL_DEBUG,
> SQL_TRACE and TIMED_STATISTICS as required. If this privilege is used
> to set any other parameter values without prior agreement, the
> privilege will be revoked."
>
> Is it just me, or is he being a bit ... well, anal?

Quite possibly.

> What possible reason would he have for doing this?

A lot of this might depend on your environment. On most of the systems I've seen, the ALTER SESSION privilege is already granted to the CONNECT role, so this is almost redundant.  

> Incidentally my login.sql script does (and always has done)
> "ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YYYY';"
> so I'm screwed anyway :-/

Which suggests you already have the ALTER SESSION privilege. Maybe you should ask him?

-- 
The underscore character does not belong in my address. You know the drill...
***
Anyone sufficiently smart enough to configure and use USEnet for research should
be smart enough to Read The Freakin' Documentation!