We have a system whereby users can attach databases from partners and third parties for analysis. I need to set up a policy whereby certain users automatically have read/write access to any new database that gets attached.
Currently these users have sa privileges which I am not happy about, would just assigning them the Database Creator role suffice?