When I try to execute grant permissions on an Assembly for users I get the following message:
Incorrect syntax near 'EXECUTE...'.
This problem has only come about with SP2, MS took away the ability to grant execute permission on UDA's. The loop whole is that they didn't take grant execute permissions away on the database that the UDA sits in. So by doing GRANT EXECUTE on the entire database for your login you can control grant permission. However, this is not the ideal solution to this problem and would like some advice on how we can set permissions on assemblies.
NOTE: I have already looked into permissions of an assembly such as SAFE_ACCESS, EXTERNAL_ACCESS, UNSAFE_ACCESS, funny thing is with it set to SAFE_ACCESS by default, the strongest security!! You would think that this would be the new way to control permissions but this makes no difference.
Any advice would be great