How will you enforce security using stored procedures ?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
How to prevent unauthorized use of privileges granted to a Role ?
What is user Account in Oracle database ?
What is default tablespace ?
what is snapshot log ?
How can you Enforce Refrencial Integrity in snapshots ?
What is Statement Auditing ?
Differentiate simple and complex, snapshots ?
What are the various type of snapshots ?
How can you enable automatic archiving ?
What are roles ? How can we implement roles ?
What is Object Auditing ?
What is Privilege Auditing ?