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

Home Home
Oracle Monitoring
Growth Monitoring
Emergency DBA Support
Installs & Upgrades
Oracle Migration
Oracle Support Plan
Oracle SQL Tuning
Oracle Performance Tuning

 Our Remote DBA Clients

 

Free Oracle Tips


 
HTML Text

Free Oracle App Server Tips


 
HTML Text

 

   
  Oracle Tips by Burleson

Chapter 4 General Oracle Security

PRIVILEGE

DESCRIPTION

ALTER

Allows the grantee to modify the structure as in ALTER TABLE. This is valid only for tables and sequences. No other user can alter any other object types owned by other users.

DELETE

Allows grantee to delete records in that object. This is valid only for tables, views and materialized views. Note that the DELETE privilege makes sense only when the materialized view is updateable.

EXECUTE

Allows the grantee to execute some stored code. Naturally, it's applicable to only the code in the database such as procedure, function, package, library, methods inside user-defined types, user defined operators and index types.


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

 

Burleson Oracle consulting & training



 

 

WISE Oracle monitoring software
 

 

Oracle forum for DBA 

 

Rampant TechPress Oracle book publisher

image 

  

 

E-mail us for BC Oracle support:   

Copyright © 1996 -  2012 by Burleson Enterprises. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.