November 26, 2010 at 3:29 am
Hi,
I am created a user ABC, i want to this user expire after 21 day's......
Please if you have query or else update me immediately..
Thanks & Regards
Saltish
November 26, 2010 at 3:50 am
From Books Online:
CHECK_POLICY = { ON | OFF }
Applies only to SQL Server logins. Specifies that the Windows password policies of the computer on which SQL Server is running should be enforced on this login. The default value is ON.
If you want the expiry period to be 21 days, you need to set your local Windows or domain policy to be 21 days.
John
November 26, 2010 at 3:53 am
hi,
If any possibality in SQL i want apply the police to user....
Satish Saidapur
November 26, 2010 at 4:00 am
I don't think you can. But read the ALTER Login topic in Books Online - you may or may not be able to find a way round it by periodically forcing the user to change the password.
John
November 29, 2010 at 1:24 am
saidapur_satish (11/26/2010)
Hi,I am created a user ABC, i want to this user expire after 21 day's......
Hey,
Please provide more details like below
1. ABC use mean - Login or Database user?
2. User Expire? - Password can expire.
If you are using Domain users you can make Group Policy to expire password as desired by you. Or you can all achieve something like that using Login Trigger
Ram
MSSQL DBA
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply