How to disable SQL Server Management Studio for a user

3740 pts.
Tags:
SQL Server
SQL Server Management Studio
Is there a way to prevent users from getting into SQL Server Management Studio so that they can't just edit table rows manually? They still need to access the tables by running my application.


Software/Hardware used:
SQL Server Management Studio
1

Answer Wiki

Thanks. We'll let you know when a new response is added.
Hi,
Firstly, protect SQL logins for the specific Databases that have read/write permissions applied to them and then change the password. If they have access to the DB via Windows Authentication, make sure that they are in a data reader role. You can use roles to manage what the users can do in SQL. I hope this helps you.
Thanks & Regards
Clark Kent

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • edwinjhoffer
    Thank you for your response. It was really helpful.
    3,740 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: