Hi there

This is a very poor question actually and doesnt really

make sence. Sure, you can remove the role from all depts

but in reality this could be opening a major can of worms in

terms of security. The rest of the options are not too much cop

either.

DAVNovak is right on the money and would have been a better answer

to throw in the mix.

Cheers

Ck

Chris Kempster

http://www.chriskempster.com

Author of "SQL Server 2k for the Oracle DBA"