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 |
|
rushdib
Yak Posting Veteran
93 Posts |
 Posted - 2004-09-21 : 10:48:45
|
| Hi,If a stored proc uses a table for deleting, inserting and upating records, and if the users has permission to execute the proc, do they need insert, update, delete permission on the table as well?Thanks,Rushdi |
|
|
raymondpeacock
Constraint Violating Yak Guru
367 Posts |
Posted - 2004-09-21 : 10:49:42
|
| No.Raymond |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-09-22 : 02:09:50
|
actually they do if the sproc is not owned by the dbo  |
|
|
|
|
|
|
execute permission and table permission