Deny login to specific users

From: LazyDBA (LazyDBA_at_discussions.microsoft.com)
Date: 01/29/05

  • Next message: Curious George: "Thanks (and apologies) for your comments on "The Most Obvious Question You Are Ever Likely To See" (e.g. No-Brainer security question)" 
    Date: Fri, 28 Jan 2005 17:27:02 -0800

    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: Curious George: "Thanks (and apologies) for your comments on "The Most Obvious Question You Are Ever Likely To See" (e.g. No-Brainer security question)"

    Relevant Pages

    • Re: Unexpected Login Screen When Accessing SQL Data Via .NET Intra
      ... >> data and the SQL Server is on the same server. ... >> My problem is that one user has started getting a login popup ... >> right in via Windows Authentication like everyone else and like they ...
      (microsoft.public.sqlserver.connect)
    • Re: cannot acees two databases as owner
      ... it does not matter you are a member of the ... the sysadmin fixed server role or if there is no any other Login which is ... group if it's a domain) and you can login to your SQL Server with, ...
      (microsoft.public.sqlserver.setup)
    • Re: Database security design with ASP.net and form-based authentication
      ... Since you already have forms-based security, why not use a single SQL login ... for all database access? ... data entry, guest/view only, admin, report viewer. ... so I'm using SQL Server authentication. ...
      (microsoft.public.sqlserver.security)
    • Re: Credentials not being passed with remote access
      ... allowed windows authentication to work, ... I had assumed johnx was a domain user rather than a local Windows account. ... johnx was set up as a local login on sql server. ...
      (microsoft.public.sqlserver.security)
    • Re: No db access after publishing web site
      ... GRANT UPDATE TO ... If I detach and attach this database on a different PC (according that PC ... Cannot open database "pago" requested by the login. ... Are you detaching/attaching the SQL Server Express database correctly ...
      (microsoft.public.dotnet.framework.aspnet)