November 2, 2009 at 3:45 pm
I have a developer who has an app that uses a generic account that runs a stored proc which utilizes a execute as. However I am getting the error
not able to access the database "Plandata" under the current security context.
I thought I had everything set with the execute as but not working, any good place to start
November 3, 2009 at 3:19 am
does the execute as account have permissions/access to that database.
list the account/user and its permissions, that is usually the best starting point
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
November 3, 2009 at 7:30 am
yes it is a sysadmin account
November 3, 2009 at 7:33 am
then i dont understand, sysadmin will have access to everything.
Can you confirm that the execute as account is a sysadmin account. if it is, sounds like you havent created the stored proc correctly.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
November 3, 2009 at 7:36 am
if you execute the stored procedure yourself, running under the security context of that account, does it work?
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply