DECLARE @sql NVARCHAR(MAX) = N'';
SELECT @sql = @sql + 'GRANT INSERT, SELECT, UPDATE ON ' + QUOTENAME(OBJECT_SCHEMA_NAME(object_id)) + N'.' + QUOTENAME(name) + ' TO [YourRoleName];
'
FROM sys.views
WHERE name LIKE 'zvw%';
PRINT @sql;
--EXEC(@sql);
code]
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato