Re: can you set a time out setting on a database login

From: sniper (andyrightin@yahoo.com)
Date: 02/05/03 

From: "sniper" <andyrightin@yahoo.com>
Date: Wed, 5 Feb 2003 00:07:24 -0800

Thanks !! a lot
just one more question
 can an intercative login be disabled and still the user
can access the database ??? ie he cannot login through
isqlw ????
ur help will be appreciated

>-----Original Message-----
>Not on the db level, but you can use Windows integrated
security. Win 2000
>has a lot of options for controlling user accounts, like
expiration date,
>permitted logon hours etc. Besides that, you have account
policies, like
>password and account lockout policy.
>
>--
>Dejan Sarka, SQL Server MVP
>FAQ from Neil & others at: http://www.sqlserverfaq.com
>Please reply only to the newsgroups.
>PASS - the definitive, global community
>for SQL Server professionals - http://www.sqlpass.org
>
>"sniper" <andyrightin@yahoo.com> wrote in message
>news:008001c2cc0e$7bfecda0$8df82ecf@TK2MSFTNGXA02...
>> Hi,
>> can anyone tell me whether i can set a lockout policy or
>> timeout policy i.e. the login does not get access to the
>> database after 25days or 30 days etc like in oracle,can
we
>> do it in SQL 2000 or 7.0 at the database level ?
>>
>> ur help will be appreciated !
>>
>> sniper
>
>
>.
>

Relevant Pages

  • Re: Please! Doesnt anyone know a better way to do this?
    ... account, they need to automatically be directed to the page to enter data ... session variable on the Account page. ... I assume here that you're checking a database when the user attempts to ... When a new user attempts to login or clicks to register, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Security controls in a web application
    ... one may be better off passing account management tasks ... to the operating system or database server ... I'm afraid that my web app is lacking of many security controls. ... I have implemented some security controls like a login page that asks ...
    (microsoft.public.security)
  • Re: sp_addrolemember with Windows SQL Server Login
    ... error as long as a valid domain account was specified. ... SQL Server apparently allows you to add a Windows account to a database ... he noticed that User1 was a NT Login ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Connection String using Domain Account
    ... The DBA has given me a Domain user account with rights to the ... | to get a connection to the database. ... or Login failed for userID. ... You can map a domain account to a SQL login, see CREATE LOGIN in SQL books ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: RESTORING CRASHED SITE WEBS
    ... Well, when installing Sharepoint, the installer did display a message ... I can't login using any existing accounts. ... >> access using Windows Security the account returned in the failed ... I put in the database server name and ...
    (microsoft.public.sharepoint.windowsservices)