Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
alun02
Starting Member
5 Posts |
 Posted - 2008-07-02 : 07:32:27
|
| Hi,I'm doing some work on a third party db, which I have a copy of running locally, and I am connecting to from a locally running ASP website. I am logging in using integrated security and whilst i can access the db, once I try and run a stored proc I get a message saying 'Could not find stored procedure'. I believe the problem is that the proc is owned by a third party user account. What I would like to do is give the IUSR_ account which I am accessing with rights to access everything in the db. I have tried making them a member of the db_owner role but to no avail.Any suggestions would be gratefully recieved.ThanksAlun |
|
|
alun02
Starting Member
5 Posts |
Posted - 2008-07-02 : 12:47:47
|
| In case anyone else is interested, I fixed the problem by getting a script to make IUSR_ account the owner of all the database objects (other than the system ones obviously). It's a hack I know, but as the work I need to do is all on the code of the site rather than the db, and as it works I'm happy enough! :) |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-03 : 23:37:36
|
| Or you can just call object with owner like abc.tab_name. |
|
|
|
|
|
|
Permission issues (I think)