We help IT Professionals succeed at work.

Possible to deny sa access to Database?

Brian Crowe
Brian Crowe asked
on
Medium Priority
604 Views
Last Modified: 2009-07-29
Is it possible to deny a system administrator access to a particular database?  The situtation is this...we are installing an application and database on a client's server.  They would like us to use their SQL Server to host the database for maintenance issues but we don't want to allow them unfettered access to the database.  Is this possible and how?

BriCrowe
Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2012
Commented:
You cannot deny sa to specific databases.  You can deny sa from the whole server by setting SQL Server to use Windows Authentication only.

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Cant comment on SQL 2005 as i dont know enough about it yet,  but if this is SQL 2000 then irrespective of what SQL permissions are granted, if someone stops sql and attatches the DBs to another SQL database then the'll bypass the security.   The only thing you can do is either secure the box itself (ie not on clients server) or encrypt the database.

Commented:
acperkins is right. The sa has rights in every database.
Brian CroweDatabase Engineer
CERTIFIED EXPERT
Top Expert 2005

Author

Commented:
That's what I figured.  I just wanted to make sure that I wasn't missing something.  Thank you all for your comments.
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.