SELECT *, 'GRANT VIEW DEFINITION ON [' + s.name + '].[' + o.name + '] TO [db_view]' FROM sys.objects o JOIN sys.schemas s ON o.schema_id = s.schema_id WHERE type = 'V' AND create_date > '2021-09-20' AND is_ms_shipped = 0 ORDER BY create_date DESC;