question about "sql security"

[wangxu]

I refer a question about "sql security" option of create procedure syntax at 
2005-12.
But i can't quite understood with that answer.
Can you give me a example to describe the effect of set "sql security" option ?