I've inherited an RDS instance, and I'm trying to figure out a way to create a server role as similar to that of SA as I can, so that I can give it to a couple of additional employees, without having to share the Master User. DBCreator is out, SA/sysadmin is out, securityadmin is out, and I'm not sure what I can do. THis seems like a pretty major hole, not being able to manage users/groups without using the master account. I can give their accounts DBO and security permissions per database, but the second a new database is created, they don't have that any more, and I can't find a way to auto-grant permissions to a created server role at the database level. Any ideas?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.