Call for Oracle support & training (800) 766-1884
Free Oracle Tips

Home
Corporate Oracle Training
Custom Oracle Training
Oracle New Features Training
Advanced Oracle DBA Classes
Oracle Tuning Courses
Oracle Tips & Tricks
Oracle Training Links
Oracle Training Links
Oracle Training Links

We are top for USA Oracle Training Clients

 

Free Oracle Tips


 
HTML Text AOL

Free Oracle App Server Tips


 
HTML Text

Oracle support

Oracle training

Oracle tuning

Rednecks!

Remote Oracle

Custom Oracle Training

 

   
  Oracle Tips by Burleson

Chapter 2 Introducti

on to Oracle Security

Let's ponder over a question here. Sue is driving a car owned by Mr. Smith, and he has given her permission to do so. Should she carry her own driver's license?

While we deliberate over the question, she zooms off to the drug store; but in her excitement, she races the car at 80 miles per hour! And within no time, there is a police officer right behind her with flashing lights.

When Sue gets the ticket for speeding, who do you think the ticket should go to - her or Mr. Smith? You might argue - why Mr. Smith? He was not driving, Sue was. Therefore, she should receive the ticket, and she did. What would have happened if she had told the officer that Mr. Smith owns the car, and he should be responsible for the speeding violation? The officer probably would have laughed.

This is an important concept to understand. Although Mr. Smith owns the means of delivery, and he gives Sue permission to operate the means of delivery, Sue carries out the operation and is responsible for actions like speeding. In a database application, a similar question also arises. Security procedures might dictate that all applications in the form of stored procedures and packages be owned by a secure user, and that execute permissions only be granted to the other users who might need them. However, the stored procedure should update the tables only when the application users have privileges to update them.

Perhaps an example will help illustrate the concept better. Take the example of the procedure update_claim_amount above, but assume it is owned by
 

The above text is an excerpt from:

Oracle Privacy Security Auditing

The Final Word on Oracle Security

 

This is the only authoritative book on Oracle Security, Oracle Privacy, and Oracle Auditing written by two of the world’s leading Oracle Security experts.

This indispensable book is only

$39.95

 and has an immediate download of working security scripts:

 

http://rampant-books.com/book_2003_2_audit.htm



 
 
 
 

Oracle performance tuning book

 

 

Oracle performance tuning software

 
Oracle performance tuning software
 
Oracle performance Tuning 10g reference poster
 
Oracle training in Linux commands
 
Oracle training Excel
 
 
 
 

 

email BC:


Copyright © 1996 -  2014 by Burleson Inc. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.