Can users who are members of SQL2008's server DBCreator role, access databases created/restored by another user with the same permissions, without having to grant any additional permissions?
SnapOverflow
Can users who are members of SQL2008's server DBCreator role, access databases created/restored by another user with the same permissions, without having to grant any additional permissions?
The user becomes the owner of any database they create (meaning they can do pretty much anything to it including rename it or drop it), but they are unable to access databases created by other db_creator members.
More info here