On 03/07/2013 03:10 AM, MURAT KOÇ wrote:
> Hi list,
> In Oracle, it could be created a user profile called "PROFILE" and this
> profile could have below specifications:
> PASSWORD_LIFE_TIME (that describes when password will expire)
> FAILED_LOGIN_ATTEMPTS (specifies number of failed login attempts before
> locking user account)
> PASSWORD_LOCK_TIME (specified time after user account is locked
> because of failed login attempts exceeded)
> PASSWORD_VERIFY_FUNCTION (this allows setting a strong password verify
> function - min characters, password complexity)
> Has PostgreSQL got any capability like this except LDAP, kerberos or PAM
> authentication ?
The only part of the above that I know of is VALID UNTIL
(PASSWORD_LIFE_TIME) from below:
http://www.postgresql.org/docs/9.2/interactive/sql-createrole.html
> Regards,
> Murat KOC
--
Adrian Klaver
adrian.klaver@gmail.com