often when i create a new MSSQL DB (often for Soop or WWF) - after i do the setting up, i get errors about DBO permissions. support is usually pretty quick to fix it up, but how can i avoid this in furture?
thanks.
this is an example error:
Microsoft OLE DB Provider for SQL Server error ‘80040e09’
EXECUTE permission denied on object ‘wwfSpChkUserID’, database ‘kindra_soop’, owner ‘dbo’.
/forum/common.asp, line 522
hello?
From reading some of the other posts and experiencing this myself, I believe it is necessary for support to manually grant you DBO in order to avoid this. As you said, I found them to be very responsive and cooperative about this, too.
You need to ask support for DBO permissions, this is not available in the CP unfortunately 
thanks devorem & yash!
i wish we could do stuff like this ourselves…
i’ve been stuck for a good few hours now (6+?) waiting for support to fix this for me (#36741)
Your task has been done and your ticket is replied.