Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 restricting users depending on timezones

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-01-09 : 08:32:05
vikas writes "hi everybody,
my server is in india and i want to restrict the users located all over the globe from accessing the server for a particular span of time.i have a table "user_restriction" where i would maintain the user and his restricted time ,which i would read when the user tries to login.if the user is trying to login in the time restricted for him i will not allow him the access.
E.G
suppose user1 is from US and iwant to restrict him from logging in from 10:00 to 17:00 hrs IST.then how should i maintain his time in "user_restriction" table."

Srinika
Master Smack Fu Yak Hacker

1378 Posts

Posted - 2006-01-09 : 10:19:26
How does ur users log in (I mean what is the front end used to access database)

If u use some web page to access ur database, then the webpage developing tool can be made use of, to restrict users based on SQL server's time.
eg. If its an ASP page, u can write VB Script to meet ur need..
Go to Top of Page
   

- Advertisement -