A login has server level securityadmin and dbcreator roles. This login needs to add another login to a specific database as a user with db_owner database role. The problem is that when the securityadmin & dbcreator tries to execute "USE database" he/she gets an access error message because the login isn't a user in the database. If the login has sysadmin role then he/she has access to the database. Is there a workaround in order not to give sysadmin role to the login?
View Complete Post