HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

SQL Server trusted connection additional security

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
sqlconnectiontrustedsecurityserveradditional

Problem

Using Windows authentication, is there a way to prohibit users from connecting via ODBC to the database?

Solution

The feature designed to help in this scenario is Application Roles. With an Application Role you can allow the user to connect to the target database, but not be able to run any queries until the application supplies a secret to activate the Application Role.

Context

StackExchange Database Administrators Q#251805, answer score: 8

Revisions (0)

No revisions yet.