I have a table of metadata, listing every variable in every table in my database, which when a variable is flagged as 'Released' it triggers a stored procedure to deny
UPDATE permissions on that field in its respective table, and also deny
DELETE permissions on the table as a whole, for 3 specific Users everytime.
It works perfectly! But I'd like some kind of checking method that I can run every so often to confirm that all released variables have had their
UPDATE permissions removed for these 3 Users - so I can check no pesky admins have gone in and changed them sometime!
Is there a way I can see the fields in every table in a database, along with their UPDATE permissions for each User, so then I can compare it to my metadata table to confirm Released columns have indeed had their
UPDATE permissions altered?
I am using SSMS v17.9.