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.
14,494 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,705 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.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.