Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Ryan Randall Copy Permissions for a database RE: Copy Permissions for a database
figaro
SSC Enthusiast
Points: 195
More actions
April 16, 2009 at 4:27 pm
#979315
works great with the function as was posted.
I just added double quotes on the line #92:
set @s-2 = @protect_type_name + ' ' + @action_name + ' ON ' + @object_name + ' TO "' + @to_user + '"'
to support "DOMAIN\user" format.
thanks.
Roberto Figueroa.