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 |
|
mmkrishna1919
Yak Posting Veteran
95 Posts |
 Posted - 2014-01-02 : 09:03:20
|
| I have a new table "customer" in my schema "dev"and i have new stored procedure "add_customer" in my schema "dev"in Stored procedure i am inserting/deleting records into/from table "customer".If a user want to execute StoredProcedure does he need permissions on both table and StoredProcedure? orpermissions on StoredProcedure will enough..to execute the SP?ThanksM.MURALI kRISHNA |
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2014-01-02 : 09:33:28
|
| You need EXECUTE premissions only on Stored Procedure--------------------------http://connectsql.blogspot.com/ |
 |
|
|
ovc
Starting Member
35 Posts |
Posted - 2014-02-01 : 19:05:42
|
| you will need access also to the underlying objects.If you do not want to add permissions to the underlying table, you can run the stored procedure within a different context by adding to the definition of the stored procedure "execute as yourdefinedusername".For more info check:http://technet.microsoft.com/en-us/library/ms187926.aspxRegards,Octavian |
|
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2014-02-01 : 23:31:19
|
| OVC, you are correctArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
|
|
|
Access rights