sql server new users: Will it is possible to set a login in sql server for 10days -- sql server new users

Re: Will it is possible to set a login in sql server for 10days

csesaravana NO[at]SPAM gmail.com
5/25/2006 6:41:02 AM

Hi Tom,
We are using sql server 2000.
Creating job is also not accetped by the clients!!!
Do we have any other method of setting security and encryption for
login
Thanks,
Saran

[quoted text, click to view]

Re: Will it is possible to set a login in sql server for 10days

Stu
5/25/2006 7:53:37 AM

Well, if you can't programmatically schedule it, then no. Tell your
client to put a reminder in Outlook to disable the login.

Stu

Re: Will it is possible to set a login in sql server for 10days

Tom Moreau
5/25/2006 8:58:22 AM

What version of SQL Server are you using? In SQL Server 2005, you can
create a scheduled job to run ALTER LOGIN to disable it. Make the schedule
run in 10 days. In SQL 2000, you could have the job just run sp_password
against the login with some random password. That essentially keeps the
user from logging in.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
..
[quoted text, click to view]
Hi ,
I am working as a Database Adim
I am providing support Application projects
Here is my issue,

Can we able to provide access for a login only for 10days
Is there is any other way apart from Windows Authentication ?
Please help me

Thanks in Advance
Saran

Re: Will it is possible to set a login in sql server for 10days

Andrea Montanari
5/25/2006 2:55:40 PM

hi Saran,
[quoted text, click to view]

if you are using SQL Server 2005 you can enforce Windows policies for SQL
Server standard logins as well, but on SQL Server 2000 you are out of luck..
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://italy.mvps.org
DbaMgr2k ver 0.19.0 - DbaMgr ver 0.63.0 and further SQL Tools
--------- remove DMO to reply

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server new users group.