How will you enforce security using stored proce

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

218. How will you enforce security using stored procedures?

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.

(Continued on next question...)

Other Job Interview Questions

• What are the types of calculated columns available?
• What is the use of transactional triggers?
• What is Table?
• What does ROLLBACK do?
• What are the default parameter that appear at run time in the parameter screen?
• What is a Database instance?
• What are the use of Roles?
• What is coordination Event?
• What are the two panes that Appear in the design time pl/SQL interpreter?
• Where would you look for errors from the database engine?
• More...