Want block dynamic query or on the go user written query

Kiritkumar Baraiya 1 Reputation point
2021-07-14T04:05:32.837+00:00

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
Transact-SQL
Transact-SQL
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
    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.