|
Home > Archive > SQL Anywhere database > 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.
|
|
|
| should have option to expire pwd for users.
Also for Mobilink users.
Thanks
VSV
| |
| Mark Culp 2005-12-09, 8:24 pm |
| 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
| |
|
| sorry for the wrong group.
rest in the right one.
"Mark Culp" < reply_to_newsgroups_
only_please_nospam_m
ark.culp@iAnywhere.com>
wrote in message news:4399FD1F.8A4868F8@iAnywhere.com...[color=darkred]
> 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:
|
|
|
|
|