How will you enforce security using stored procedures ?

Answer Posted / sudhakar

set role to users dynamically, the user to have just the
connect role initially and execute permission to the store
proc which authenticates the user. Upon authentication, set
the role required accordingly within the store proc.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

No New Questions to Answer in this Category !!    You can

Post New Questions

Answer Questions in Different Category