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.
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.
Who is Participating?
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
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
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.
Absolutely. It is called SQL Server permissions. You GRANT the necessary permissions to the user to do their job and nothing else.