Re: Serialization issue on Oracle 10g

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 20 Aug 2006 14:39:43 -0700
Message-ID: <1156109983.468774.184660@h48g2000cwc.googlegroups.com>

Brian Peasland wrote:
>
> I prefer:
>
> ALTER USER bad_user ACCOUNT LOCK;
>
> Makes my job much easier!!!
>

Probably a better approach is to attempt to educate bad users and possibly their management.

There are various approaches available to reduce the amount of impact "bad users" can have on a production system.

Locking accounts without a documented policy in effect is an approach likely to create political problems between dba's and the parts of the rest of the organization. Received on Sun Aug 20 2006 - 16:39:43 CDT