Preventing access to a database temporarily

[arrow483]

Here's what I am trying to do. We have a job that runs a DTS (this is working). What I want to do is prevent a user group from accessing this db while the job is running.

This is setup under SQL server agent / jobs as a timed job.
Here's what I have so far.

Step 1

DENY SELECT ON frl_entity TO [Frx DesignersLaunchers];

Step 2

DTS …..

Step 2

REVOKE SELECT ON frl_entity TO [Frx DesignersLaunchers];


But frl_entity is a table. I would prefer the entire DB be restricted. Actually, if I could just disable the login temporarily it would be better, but I can't figure how to do that automatically.

 

[arrow483]

Oops. I posted this to wrong forum. I reposted in SQL forum.