Password last changed date & time for database user?

sunmorningindia

We are using database user (SQL Server authentication) in NAV 5 SP1 with "Enforce password policy" and "Enforce password expiration". We want to find password last changed date & time for a database user so that we can send password expiration notification. We can do this for AD user but don't know how can I do this for database user?

Thanks,
Manish

mohana_cse06

did you try by writing following code in OnModify() trigger of table User - 2000000002

"Expiration Date" := CALCDATE('<1M>',TODAY);

sunmorningindia

Thanks for ur reply.

Database user can change password from "Tools->Security->Password".
This option does not call modify(true) on Table 2000000002 User.
Is there any other way to call modify(true) in this case?

mohana_cse06

Did you try that?
It worked for me even if i change the password

sunmorningindia

I checked this again in my test environment, still no result.
Environment: NAV 5 SP1 IN
SQL Server: 2008 R2 Express

I just add code as :
OnModify()
"Expiration Date" := TODAY;

When I change password for test user, the "Expiration Date" field still blank.

What was your test environment?

sunmorningindia

Finally this workaround will help me,

Call SQL Statement as : select [modify_date] from [master].[sys].[server_principals] where [name]='userid';
Capture the output and enjoy....

Anyway, I will still search for a solution like suggested by "Mohana"

Thanks,
Manish

mohana_cse06

I tried that on native database...

sunmorningindia

:P ,
This workaround is good for this time.