Link to home
Create AccountLog in
Avatar of kyleshire
kyleshire

asked on

Disable users from utilizing SSMS

Hi,

I have some users in my company that access our Production SQL instance via SSMS. I would like to know if there a way to block all domain users from using SQL Management Studio, except domain admin, as domain admin has 'sysadmin' rights.

We have software that utilizing Integrated Security.  I would still like our users to be able to utilizing our software using the SQL Windows authenticate, but not able to logon via SSMS.

Thanks!!
Avatar of Nakul Vachhrajani
Nakul Vachhrajani
Flag of India image

What would be the business rationale behind this? Is it that you don't want users to make changes to the DB configuration/schema?

If yes, you can deny those permissions and setup appropriate auditing. It is possible to configure such that users can only view the schema and select/add data.
SOLUTION
Avatar of chaau
chaau
Flag of Australia image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
ASKER CERTIFIED SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.

I have recommended this question be closed as follows:

Split:
-- Muhammad Burhan (https:#a42052284)
-- chaau (https:#a42052281)


If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.

Pber
Experts-Exchange Cleanup Volunteer