Can I restrict any session from altering or dropping tables

25 Views Asked by At

I have a stored procedure which picks data from a particular column from a table and execute that data, which means the data will itself be a query, most probably some update or delete or insert statements.
Now the problem is, there is a high risk of the tables getting altered or dropped because this data can be any statements which the user inserts(of course there are approval scenarios and status checks and all ,but still..) .
And there is a restriction of using the user login(which have ddl permission) for the web app, so I cannot restrict based on login. Is there any way so that this particular session which executes the statement can be restricted from any ddl permissions?

0

There are 0 best solutions below