Link to home
Start Free TrialLog in
Avatar of SasDev
SasDevFlag for United States of America

asked on

Prevent Network Administrators from access to sql database tables

I have an employee database and I want to restrict access to specific tables to only a couple of people not including the Network Admins. What would be the best way to go about doing this seeing as though they know the sa username and password? I thought about creating a group in Active Directory, then a role within SQL Server that denies that specific group access; however, they could just remove their name within the group and again have access.
I realize this is probably an obvious question but any suggestions would be helpful. Thanks

Using SQL Server 2000
 
ASKER CERTIFIED SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of SasDev

ASKER

Great suggestions. Thanks for your help!