January 9, 2008 at 4:14 am
I'm looking for some help please...
We have one production server that hosts multiple databases, we have a three sysadmin users on this server to help administrate it. However there is now a requirement to build a database that needs restrictive access to just one dba.
So the question is; is there anyway of stopping the people with sysadmin access from accessing this database i.e. deny access to a database?
PS we are running on a SQL Server 2000 standard edition server.
Any help would be great.
January 9, 2008 at 4:27 am
I don't see any besides creating separate instance of server for that database.
...and your only reply is slàinte mhath
January 9, 2008 at 5:31 am
Sysadmin can perform any activity in the sql server installation hence it's not possible.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 9, 2008 at 6:40 am
You could set some things up, like DDL triggers, but a sysadmin could disable them.
Remove them from sysadmin access if you need to.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply