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.
searchsanjaysharmaAsked:
Who is Participating?
 
Anthony PerkinsConnect With a Mentor Commented:
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
All Courses

From novice to tech pro — start learning today.