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 |
|
eric_ht
Starting Member
37 Posts |
 Posted - 2006-10-06 : 08:33:22
|
| I have a user setup on a sql server 2000 that is used to run procedures from other apps. Originally when this user was defined as dbo it worked fine. We decided it did not need to be dbo so we knocked it down a notch. It now has database roles of ddladmin, datareader and datawriter. BUT when the asp.net program trys to access a stored procedure it throws a "EXECUTE permission denied on object 'stored_prc_name_goes_here', database 'database_name_goes_here', owner 'dbo'" error. I can go into the permissions for this user and assign EXEC rights to each individual object and it works. Are there any roles that can be given to a user that it would globally give exec privledges without being a dbo? |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-10-06 : 08:44:10
|
| If the Sproc accesses objects outside the current database then it needs User Permissions on those objects (or you have to use the database chaining workaround thingie), for stuff within the current database the Sproc uses the permissions of the User which created the SprocDoes that shed any light on the problem?Kristen |
 |
|
|
|
|
|
EXECUTE permissions