Post reply

AUTOMATIC LOGIN DISABBLING

  • August 4, 2008 at 7:38 am

    #126899

    What is the mechanism in SQL server that disables a login if it has not been used for a number of days? Many thanks.

    Sahoong.

  • August 4, 2008 at 7:46 am

    #852682

    sahoong (8/4/2008)

    What is the mechanism in SQL server that disables a login if it has not been used for a number of days? Many thanks.

    Sahoong.

    It is called Password Expiration, and you can set it for logins. (see ALTER LOGIN http://msdn.microsoft.com/en-us/library/ms189828.aspx). Note that password expiration is enforced only on Windows Server 2003 and later.

    Regards,

    Andras

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply