Want block dynamic query or on the go user written query

Kiritkumar Baraiya 1

Hi All,

Is there any way where I can block dynamic SQL query or on the go user written SQL query in SQL Server.

Is there any way, please provide me the solution.

CathyJi-MSFT 20,786 Reputation points Microsoft Vendor

2021-07-14T07:22:08.117+00:00

Hi @Kiritkumar Baraiya ,

Block SQL query? Cancel the query execution? Kill the SQL query? What did you real mean? Could you describe your requirement more clearly to make us better understand.
CathyJi-MSFT 20,786 Reputation points Microsoft Vendor

2021-07-16T06:47:00.713+00:00

HI ,

Any update for this thread?

1 answer

Tomáš Zíka 256 Reputation points

2021-07-15T08:17:51.687+00:00

Prevent dynamic and ad-hoc queries from users by not giving them permissions in the first place.
Please sign in to rate this answer.
Erland Sommarskog 72,416 Reputation points MVP

2021-07-15T08:45:32.6+00:00

If that is your sole concern, just revoke their access to the database. Or the entire server.

I guess there something more to it, but rather than trying to read your mind, I think it is better that you gives us more details.
Sign in to comment

Activity