Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 527
  • Last Modified:

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!
0
salmanfazal
Asked:
salmanfazal
  • 3
  • 2
  • 2
  • +1
1 Solution
 
Bhavesh ShahLead AnalysistCommented:
Hi,

check out this post.

it may helps
0
 
salmanfazalAuthor Commented:
which post?
0
 
Muhammad Ahmad ImranDatabase DeveloperCommented:
the proper way is using grant permissions to particular user.
0
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 
salmanfazalAuthor Commented:
but the 'sa' account can override this?
0
 
armchangCommented:
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
 
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

Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

  • 3
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now