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?
 
ArmandProgrammer / DeveloperCommented:
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
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

 
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.