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 |
|
sqlfresher2k7
Aged Yak Warrior
623 Posts |
 Posted - 2013-05-31 : 17:02:06
|
| A user requested to grant view definition of a stored procedure.What is the impact if we granted the view definition to the user apart from viewing the code of stored procedure. |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-05-31 : 17:15:59
|
| I don't think it has any other side effects; see the description here: http://msdn.microsoft.com/en-us/library/ms175808(v=sql.105).aspx |
 |
|
|
djj55
Constraint Violating Yak Guru
352 Posts |
Posted - 2013-06-03 : 10:06:36
|
| James is correct, however make sure the stored procedure has no information that could provide restricted information such as RUN AS. Or if there is hard code of sensitive information (I found a hash seed in a stored procedure).djj |
|
|
|
|
|
|
Question