How can we assign a user , e.g.: the database owner (DBO) the UNSAFE ASSEMBLY permission?
I'm asking it to enable a user to create an assembly and don't know the SA password, so
EXEC sp_changedbowner ‘sa’ can't help.
Only users mapped to a login that's a member of the sysadmin fixed server role can create and alter an assembly with an UNSAFE permission set defined. Therefore, to achieve your desired result you would have to add that respective login to the sysadmin fixed server role.
UNSAFEenables the code in the assembly complete freedom to perform operations in the SQL Server process space that can potentially compromise the robustness of SQL Server.
UNSAFEassemblies can also potentially subvert the security system of either SQL Server or the common language runtime.
UNSAFEpermissions should be granted only to highly trusted assemblies. Only members of the sysadmin fixed server role can create and alter