With the move to Azure Cloud things are moving fast! I have a question based on Azure VM with a shared SQL Server containing multiple instances.
For example if a Azure VM has 5 instances on there each with different databases, and a vendor logs in to our Azure VM is there a way to lock down what they can access? I know you can assign DB_Roles for the vendor to only view the database they need, but how about for drives and the files within those drives?