Re: How to disable password checking for a profile?

From: Vladimir M. Zakharychev <bob_at_dpsp-yes.com>
Date: Tue, 27 May 2003 14:55:37 +0400
Message-ID: <bavg7d$kp5$1@babylon.agtel.net>

"Peter" <peter_at_nomorenewsspammin.ca> wrote in message news:t9j5dvoe1o7m2i2a3j6unsd6s9gujj75ks_at_4ax.com...
> Is there any way to disable password checking for a profile?

There isn't, as the password is an attribute of a user, not of a profile, and authentication takes place before the profile is applied. Profiles are there to limit resource usage by particular users. What you're looking for is rather removing an inherent limit on database accessibility.

However, if by "password checking" you mean password complexity verification, then it can be disabled by issuing

ALTER PROFILE xxx LIMIT PASSWORD_VERIFY_FUNCTION NULL;

-- 
Vladimir Zakharychev (bob@dpsp-yes.com)                http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.

Received on Tue May 27 2003 - 05:55:37 CDT