Interested to Buy Any Domain ? << Click Here >> for more details...
How will you enforce security using stored procedures ?
- 2 Answers
- 5799 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
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.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / sudhakar
set role to users dynamically, the user to have just the
connect role initially and execute permission to the store
proc which authenticates the user. Upon authentication, set
the role required accordingly within the store proc.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the use of ANALYZE command ?
What is Tablespace Quota ?
How can we specify the Archived log file name format and destination ?
What are the benefits of distributed options in databases ?
What are the different Levels of Auditing ?
What is a trace file and how is it created ?
what is the step for rmanbackup?
How can we reduce the network traffic ?
What is Statement Auditing ?
What are the minimum parameters should exist in the parameter file (init.ora) ?
what is meant by physical order and logical order in clustered index and non clustered index.
How can you enable automatic archiving ?
Oracle General 
