Hello David, 

> -----Original Message-----
> From: David P Possinger [mailto:[EMAIL PROTECTED] 
> Sent: Thursday, July 14, 2005 7:32 PM
> To: [email protected]
> Subject: Password Information
> 
> Is there anyway to enforce certain password criteria such 10 character
> in length and must include numbers and special characters?
> 
> Also, to force the user to change their password after a 
> certain amount of time?

Unfortunately, none of these features exist.

> In what tables/files are the passwords located?

The passwords itself are not accessible by SQL statements but 
stored in the database like other database objects.

However, the columns PWCREADATE and PWCREATIME of the system table
USERS show you date and time of the last password change (or the 
time of the initial password creation if the password hadn't changed 
since then).

Regards
Alexander Schröder
SAP DB, SAP Labs Berlin

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to