I have a system win server 2008/ sql server 2008 r2 where sql server is accessed by remote user (the same but multiple connections).
I need to have a user who can create/alert databases but I do not want to put him in sysadmin.
When I add user to public and dbowner role that is enough to run query and create databases but he can not alter database. Granting user explicit permission to alter has no effect. The only time it works is when I put user in sysadmin role.
When user creates database from remote location (c# exe) I need to alter several options because I do not need transaction logs for example.