Oracle Security Question:
How to enforce security using stored procedures?
Answer:
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.
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.
| Previous Question | Next Question |
| Explain What are the dictionary tables used to monitor a database spaces? | Tell me What is user Account in Oracle database? |