Re: Deny login to specific users

From: Dejan Sarka (dejan_please_reply_to_newsgroups.sarka_at_avtenta.si)
Date: 01/30/05

  • Next message: Agent_C: "Re: Spotting Seedy Recruiting Firms"
    Date: Sun, 30 Jan 2005 11:16:59 +0100
    
    

    Hi!

    SQL logins do not support account or password policies. Use Windows logins
    and their policies.

    -- 
    Dejan Sarka, SQL Server MVP
    Associate Mentor
    www.SolidQualityLearning.com
    "LazyDBA" <LazyDBA@discussions.microsoft.com> wrote in message
    news:AA50FD81-0840-4440-A580-2650E7B68BB6@microsoft.com...
    > Hi,
    >
    > Is it possible in SQL Server 2000  restrict a SQL User's login hours?
    > I dont want some users to login between 2200 and 2400.
    >
    > Thanks
    >
    >
    

  • Next message: Agent_C: "Re: Spotting Seedy Recruiting Firms"

    Relevant Pages

    • Re: System Administrator Implied Permissions
      ... >> Hi Dan, ... >> Now, given this, why does SQL Server ... However, these logins were not ... Other sysadmin role members have the ...
      (microsoft.public.sqlserver.security)
    • Re: SQL Server 2005 Login Problem
      ... There are two authentication method in SQL Server. ... 1- Windows Authentication ... Only creating Logins is not the complete solution of course, then you'll need to map those users to the appropriate databases and assign them roles and grant them permissons. ...
      (microsoft.public.sqlserver.clients)
    • Re: Windows permissions to run Jet OLEDB 4.0
      ... in SQL Server or not when you have to go outside of the server to the ... Actually I was talking about Windows logins. ... There is no security whatsoever implemented on the mdb ...
      (microsoft.public.data.oledb)
    • Re: Logins & Permissions
      ... At server level, we use "Logins" to connect to a SQL Server Instance and perform server level jobs. ... "Users" are used and these users are mapped to Logins. ... I am using SQL Server 2005 on a Windows NT Network ...
      (microsoft.public.sqlserver.security)
    • No Application Logins Allowed - SOX
      ... I'm trying to work through an issue regarding our MS SQL Server logins. ... "Customer" application uses a login to SQL Server called "Customer" and the ... Grant our users Windows Authentication access to SQL Server. ...
      (microsoft.public.sqlserver.security)