Hi there
I trust you are well
Please can you advise if you have managed to find a way to achieve this yet. So we want to hide all Databases except the db owned by a user (Created by solidcp) who can login with SQL management Studio.
Also is there a way to specify at the point when the Sql user is created in SolidCP that it should be the owner of the db. in other words I don't want to run this "SP_changedbowner 'n Go " afterwards.
thanking you in advance.
Hello,
Sorry for my late reply.
To my knowledge it's not really possible to disable the listing of the databases per user via SolidCP as solidcp requires certain access to backup/ truncate / delete databases, i did read up on contained databases option which might apply here, i have however not yet tried this my self yet.
Regards,
Marco
