Database Administrator (DBA) Question:
Download Job Interview Questions and Answers PDF
How will you enforce security using stored procedures?
Answer:
Do not 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.
Download Database Administrator (DBA) Interview Questions And Answers
PDF
| Previous Question | Next Question |
| What is a database profile? | What are the dictionary tables used to monitor a database spaces? |