June 4, 2008 at 10:23 am
we have created a database role named db_execute and
we have granted permission to this role on bunch of SPs
so members of that role can execute those SPs.
one of the (user)account is a member of this role
when I execute that SP in backend from this account it runs fine but
when developers call it from front end with same account they gets this error
Unexpected Database error -
ErrorNamespace: DB.SqlServer
ErrorNumber:2760
The specified schema name "dbo" either does not exist or you do not have permission to use it.
Whats should be the work around??Where should I check now?
June 4, 2008 at 11:20 am
This appears to be a duplicate posting of one in the Adminstering forum. Replies have been posted there.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply