• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 203
  • Last Modified:

How to delete or stop sql server management studio.

I have a very typical problem. The end user has the power to restore and backup the database.
The application source code in not available. The user enters the data from application.
But since he is aware of sql server he changes the data.
So for this i want to stop or disable or corrupt sql server management studio so that user is not able to edit the data from backend.,

Is there any good solution for this.
0
searchsanjaysharma
Asked:
searchsanjaysharma
1 Solution
 
Anthony PerkinsCommented:
Is there any good solution for this.
Absolutely.  It is called SQL Server permissions.  You GRANT the necessary permissions to the user to do their job and nothing else.
0
 
searchsanjaysharmaAuthor Commented:
ok
0
 
Anoo S PillaiCommented:
Hi,

A little bit late !! you have closed the question :)

Anyway,  You could use logon triggers to restrict access from sql server management studio.

Please see the link - http://www.sqlservercentral.com/blogs/erichumphrey/2011/06/18/prevent-sql-logins-from-using-ssms-_2620_-or-any-other-app/

Thanks,
Anoo
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.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now