question on asp.net 2.0, dbo permission and etc

[liming]

Hey ppl,

I always thought I needed dbo permission to run .NET 2.0 apps with the buildin membership tables/store procedures?? Because if I don't, i'd get tweird errors when i use membership api...

so I just found out earlier today that if if I do

Exec sp_addrolemember 'aspnet_Membership_FullAccess', 'yourUser'
go
Exec sp_addrolemember 'aspnet_Personalization_FullAccess', 'yourUser'
go
Exec sp_addrolemember 'aspnet_Profile_FullAccess', 'yourUser'
go
Exec sp_addrolemember 'aspnet_Roles_FullAccess', 'yourUser'
go
Exec sp_addrolemember 'aspnet_WebEvent_FullAccess', 'yourUser'
go


I was able to use .net 2.0 membership api to create user and whatever under non-dbo account, anybody knows how that worked???

and say I created some store procedures with [dbo]. prefix under my non-dbo account, how do I grant access to these store procedures for my non-dbo user accounts?

Not sure if what i said makes sense, as when it comes to permission type of topic, i'm completely clueless.

Thanks

 

[timruns]

Jodo sets all the permissions -- such as asp.net 2.0.
Just create a ticket, tell them what needs set, and they will do it pretty quick.
It would be nice if we could do some of this our own, but I am glad that Jodo errors on the side of being super-secure & safe.
Tim