Hello,
for my mssql shared hosing I have create a database and login using
security settings write by microsoft for sql shared hosting:

http://learn.iis.net/page.aspx/530/s...8-for-hosters/
http://download.microsoft.com/downlo...L%20Server.zip

but trying to publish some applications I got the following error:

Cannot find the user 'dbo', because it does not exist or you do
not have permission.

I found that the sql that generate the error is:

CREATE ROLE [aspnet_Membership_BasicAccess] AUTHORIZATION [dbo]

I have seen that adding on database the db_owner rolemember for
userlogin the problem is solved but this feature is not included in
the microsoft documents for shared hosting I think for security
reason;
On documentation for SQL2008 shared hosting Microsoft set only
(db_ddladmin, db_datareader, db_datawriter)
my problem is to find a way for add CREATE ROLE command to user login
without give it the permission for ALTER DATABASE;
with ALTER DATABASE user can modify database size or can open security
problem and I don't want this.
do you know if there is a way to solve the problem?

thanks and regards
Antony

On 03-Sep-2011 11:20, Antony wrote:
answer here.
Try microsoft.com...

--
HTH,

Rob V.
-----------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 15.0/12.5/12.0/11.5/11.0
and Replication Server 15.0.1/12.5 // TeamSybase

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks& Recipes for Sybase ASE" (ASE 15 edition)
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

rob (AT) NO (DOT) SPAM.sypron.nl | www.sypron.nl | Twitter: @rob_verschoor
Sypron B.V., The Netherlands | Chamber of Commerce 27138666
-----------------------------------------------------------------

On Sat, 03 Sep 2011 13:35:12 +0200, Rob V
<robv (AT) DO (DOT) NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY> wrote:

Hello,
thanks for your message,
I provide to forward question to other newsgroup
thanks and regards