How can I secure my Store Procedure [Resolved]

Posted by Amatya under Sql Server on 2/16/2016 | Points: 10 | Views : 1807 | Status : [Member] | Replies : 2

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

Guys .. I have a stored Procedure, I dont want any one to execute it(it is very important) because if any one executes many tables will be affected. I want some security so that that stored Procedure is lock or before Executing it some confirm message should appear. It is possible or not?

Feel free to share informations.
mail Id ' adityagupta200@gmail.com
Thanks

[Resolved]

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Rajnilari2015 on: 2/16/2016 [Member] [Microsoft_MVP] [MVP] Platinum | Points: 50

0	@Amatya Sir, You can issue permission on the SP as under GRANT EXECUTE ON dbo.procname TO username; Hope this helps -- Thanks & Regards, RNA Team Amatya, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Amatya on: 2/17/2016 [Member] Silver | Points: 25

0	Fantastic.. Their is a option.. :) I dont know that what is a Username here? Feel free to share informations. mail Id ' adityagupta200@gmail.com Thanks Amatya, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts