6.5 Group/User Permissions

Is there a way to easily disable Group/User access to a database without
having to either reset the permissions for the User and/or Group or drop the
User/Group.
In effect I want to selectively stop groups of users accessing a database
temporarily without the need to do major surgery on the object/user
permissions. Just switch them off for a short time, so to speak, and then
switch them back on again.
Please reply to newsgroup or DBA.SDC@.DIAL.PIPEX.COM
PLEASE do not crosspost to so many different sections. One, or at most two,
is enough.
Kalen Delaney
MCSE, SQL Server MCT, MVP
ukndf wrote in message <73bvgs$4k5$1@.plug.news.pipex.net>...
>Is there a way to easily disable Group/User access to a database without
>having to either reset the permissions for the User and/or Group or drop
the
>User/Group.
>In effect I want to selectively stop groups of users accessing a database
>temporarily without the need to do major surgery on the object/user
>permissions. Just switch them off for a short time, so to speak, and then
>switch them back on again.
>Please reply to newsgroup or DBA.SDC@.DIAL.PIPEX.COM
>
|||If you need to run SQL Server alone you can always start it with the single
user switch (check the docs)
If you are looking to disable users and all your security is handled via
groups you could write a short proc to move them to a group with no rights
and once you finished what you wanted to do, move them back in their groups.
Doing this would no require setting all the rights on the objects.