Thursday, November 17, 2016

GRANT CONTROL on objects in SQLserver



SELECT 'GRANT CONTROL  ON [' + SCHEMA_NAME(schema_id) + '].[' + [name] + '] TO [access];'
FROM sys.objects
WHERE type = 'FN' OR TYPE = 'P' OR TYPE='V'

No comments:

Post a Comment