Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to disable password checking for a profile?

Re: How to disable password checking for a profile?

From: Peter <peter_at_nomorenewsspammin.ca>
Date: Tue, 27 May 2003 19:09:43 GMT
Message-ID: <2td7dvkjvj562bq2dvesu7n4b3apuun46m@4ax.com>


On Tue, 27 May 2003 14:55:37 +0400, "Vladimir M. Zakharychev" <bob_at_dpsp-yes.com> wrote:

>"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;

The default value for PASSWORD_VERIFY_FUNCTION is VERIFY_FUNCTION. What does that really mean?

Thanks   Received on Tue May 27 2003 - 14:09:43 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US