Want block dynamic query or on the go user written query

Kiritkumar Baraiya 1 Reputation point

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.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,600 questions
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,544 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Tomáš Zíka 256 Reputation points

    Prevent dynamic and ad-hoc queries from users by not giving them permissions in the first place.