How will you enforce security using stored procedures ?
- 2 Answers
- 4939 Views
- I also Faced
- E-Mail Answers
Answer Posted / guest
Don't grant user access directly to tables within the
application.
Instead grant the ability to access the procedures that
access the tables.
When procedure executed it will execute the privilege of
procedures owner. Users cannot access tables except via the
procedure.
| Is This Answer Correct ? | 3 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
