Re: Oracle Default Profile Parameters

From: Howard J. Rogers <howardjr_at_www.com>
Date: Wed, 17 Oct 2001 06:23:11 +1000
Message-ID: <3bcc94f8$1@news.iprimus.com.au>

Unlimited everything. Passwords have an unlimited lifetime. They can be used an unlimited number of times. They can be changed into themselves (password reuse time is not set).

That's only be default, however. The DEFAULT profile can be changed, just like any other profile. You'll have to check dba_profiles to find out for sure.

Regards
HJR

--
Resources for OracleT: www.geocities.com/howardjr2000
=========================================


"Ed" <ejohnson_at_milleraa.com> wrote in message
news:b4d1089a.0110151113.2e79777d_at_posting.google.com...


> I have a problem with passwords expiring.  I run a query from

> dba_users and check for profiles, account_status, and expiry_date.

> The profile says default some of the accounts are locked and their are

> expiry_dates listed.  The only profile listed is the default profile

> so I wanted to know what the default profile consist of?

>

> Thanks,

> Ed

Received on Tue Oct 16 2001 - 15:23:11 CDT