One of the ways of creating an EXTERNAL_ACCESS assembly is to:
(1) CREATE ASYMMETRIC KEY from the assembly dll;
(2) CREATE LOGIN FROM the ASYMMETRIC KEY;
(3) Grant EXTERNAL ACCESS ASSEMBLY permission to the LOGIN created in previous step;
(4) CREATE ASSEMBLY ... WITH permission_set = EXTERNAL_ACCESS;
I understand that an increased level of trust is required when external resources are accessed, hence the asymmetric key.
However, I don't see what the purpose of the LOGIN is.
In BOL (http://msdn.microsoft.com/en-us/library/ms189751.aspx
) I read:Logins created from certificates or asymmetric keys are used only for code signing. They cannot be used to connect to SQL Server.
Can someone please explain what that means?
What does this LOGIN actually do?!
__________________________________________________________________________________SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based TablesPersisting SQL Server Index-Usage Statistics with MERGETurbocharge Your Database Maintenance With Service Broker: Part 2