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?
 
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: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering 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
All Courses

From novice to tech pro — start learning today.