How to enforce security using stored procedures?
Submitted by: AdministratorDon'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.
Submitted by: Administrator
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.
Submitted by: Administrator
Read Online Oracle Security Job Interview Questions And Answers
Top Oracle Security Questions
☺ | What is snapshots? |
☺ | How to specify the Archived log file name format and destination? |
☺ | Explain What are the dictionary tables used to monitor a database spaces? |
☺ | How to prevent unauthorized use of privileges granted to a Role? |
☺ | Explain snapshot log? |
Top DB Oracle Categories
☺ | Oracle PL-SQL Interview Questions. |
☺ | Oracle DBA Interview Questions. |
☺ | Oracle D2K Interview Questions. |
☺ | OCI Interview Questions. |
☺ | Oracle RMAN Interview Questions. |