SQL Server Table permission

I have an in-house developed application and  have to deploy to a client. My concern is i dont want certain tables to be touched by the programmers or administrator at the client but they are required by the application also. Client have the SQL Server "sa" account and its password.

   Is there a possiblity of protecting these tables through a password or some other means?

Thanks!
salmanfazalAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
armchangConnect With a Mentor Commented:
I think it's not possible as administrator's may have rights to modify structures of the database and the same goes with the programmers. Unless if you take away table alter, drop and add rights then they may exercise only Data Manipulation Language commands into your database which is very limited.

You may try to disable database access from the programmers and administrators which is more likely possible than disabling table access.

Does this answer your question?
0
 
Bhavesh ShahLead AnalysistCommented:
Hi,

check out this post.

it may helps
0
 
salmanfazalAuthor Commented:
which post?
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Muhammad Ahmad ImranDatabase DeveloperCommented:
the proper way is using grant permissions to particular user.
0
 
salmanfazalAuthor Commented:
but the 'sa' account can override this?
0
 
Muhammad Ahmad ImranDatabase DeveloperCommented:
how many administrators could have access this. by the way it seems odd to restrict administrators doing their job.
0
 
salmanfazalAuthor Commented:
Thnx. Its not possible actually.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.