database login Administration

wolftech

Hi expert,

a)I want to take back up, there are 40 users & runs 24*7, each at different location. I cannot tell each person not to login when I am taking back up.

How can I stop the users from loging in, during particular time which the administrator decide.

b)There are 3 department - Finance, Sales & Purchase. I want to restrict the users session based on department . eg: users under Finance dept can login maximum of 15 login, Sales 10 and purchase only 5.

Is this possible.

JPHSC

a) are you using Native or SQL ( on SQL this is no problem, on native I believe there is something like HotCopy ? [very little native expirience] )
b) you can add the department to the user setup table and count this on login ( take a look at the Session virtual table) .

wolftech

a) Yes I am using SQL Database.How to go about it

b) Can we restrict user based on that??

Thanks in advance