Oracle Security Question:
Download Job Interview Questions and Answers PDF
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.
Download Oracle Security Interview Questions And Answers
PDF
| 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? |