RajSQL
add
Refurbished Deals
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment