Home > Archive > SQL Anywhere Feedback > December 2005 > should have option to expire pwd for users.









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author should have option to expire pwd for users.
vsv

2005-12-13, 8:24 pm

Also it needs another hook while logging on.
Plus added column in the syslogin table with the timestamp.
thanks
vsv

This is best submitted to the
sybase.public.sqlanywhere. product_futures_disc
ussion newsgroup.

FWIW though, you can implement this easily yourself by using the
logon_procedure to check if the user has changed their password
since some previously stored time (in a table that you create).
You will also need to build a SP that is used that changes the
user's password (so that you can update the table storing the
timestamp when the password was last changed).

FWIW, Jasper contains a hook so you can write your own SP
that will be executed everytime a GRANT CONNECT ... is executed.
(and therefore you don't have to change your app to call a special
SP when changing the password).
--
Mark Culp
SQLAnywhere Research and Development
-------------------------------------------------------------------------
** Whitepapers, TechDocs, bug fixes are all available through the **
** iAnywhere Developer Community at http://www.ianywhere.com/developer **
-------------------------------------------------------------------------

vsv wrote:
>
> should have option to expire pwd for users.
> Also for Mobilink users.
> Thanks
> VSV



Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com