I would like to set up application role in my sql server to secure my application (.exe) . The goal is to deny all permissions of my Windows users and use the application role to do the differents manipulation.But I have 2 databases (prod and common). So I have 2 application roles and I would like to activate both at the same time.Does someone have an idea ? Thanks
I tried to set up the approle for the first database, then use an impersonate request to set the approle on the second database but it doesn't work