Foxhole Atheist
Tuesday, January 31, 2012
script to grant execute to a user
SELECT
'grant execute on '
+
name
+
' to blahuser'
AS
function_name
FROM
sys.objects
WHERE
type_desc
LIKE
'%FUNCTION%'
or
type_desc
LIKE
'%STORED_PROCEDURE%'
;
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment