I need to restrict insert permissions on a single table to a pre defined time window each day.
One way would be to craete a new user in NT and restrict login to the time window, and then only grant insert permissions on the table to this user.
better, though, would be to achieve this at DB level. Is this possible?