Ok, what are the minimum permissions required for a user to have in order to change a database owner? I read the doc, did searches, and still can't figure it out. Basically, I gave a user permissions to dbcreator and securityadmin, and assumed this was
enough to create a database, create a user, and change the owner of the database to the new user. Anyone help? I have tried several things, but I don't want to grant sysadmin rights to this box.
John M. Couch
View Complete Post