sql - Create password to insert data on table

Question

I have some canned software that uses SQL Server databases and that has little permission settings.

I don't want an user to be able to insert a data on a table if the data contains one checkbox checked,

I know what the checkbox does, it puts a 'Y' on a field on said table, I want to be able to limit only certain users to save info is that checkbox is 'Y', the table doesn't record what user is recording the data,

As I said it is a canned software, so my programmability is limited to SQL Server.

Is it possible to have a trigger to ask for a password or something if the incoming data to be recorded has an ′'Y' in the field I want to protect.

Any advice?

question from:https://stackoverflow.com/questions/65893462/create-password-to-insert-data-on-table

Answer 1

Waitting for answers