I think i'm gonna have to delegate one account for promotion(s) within specific DB and another account for server level promotion such as creating logins or scheduled jobs and etc....

Thank you for your clarification and link. It's very helpful.

Now, I'm getting convinced that db_owner is the right one to give but still have some dilemma. From time to time(but...

Thanks for your quick reply.

So, DBO would have absolute power to change anything within specific database even schema, trigger and etc?

Is there any limitation for dbo within database?