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@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
