Your question, your audience. Choose who sees your identity—and your question—with question security.
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.
Asked:
1 Solution
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.
Join & Write a Comment Already a member? Login.
Featured Post
Tackle projects and never again get stuck behind a technical roadblock.
Join Now
Absolutely. It is called SQL Server permissions. You GRANT the necessary permissions to the user to do their job and nothing else.