- Oracle Security
- Dedication
- Preface
- I. Security in an oracle System
- 1. Oracle and Security
- 2. Oracle System Files
- 3. Oracle Database Objects
- 4. The Oracle Data Dictionary
- 5. Oracle Default Roles and User Accounts
- 6. Profiles, Passwords, and Synonyms
- Profiles
- Passwords
- Synonyms
- About Public and Private Synonyms
- Examples Using Public and Private Synonyms
- Hiding the tables and owner
- Using private synonyms and path names
- Using public synonyms without user grants
- Using no synonyms/user grants and private synonyms with no grants
- II. Implementing Security
- 7. Developing a Database Security Plan
- 8. Installing and Starting Oracle
- 9. Developing a Simple Security Application
- 10. Developing an Audit Plan
- 11. Developing a Sample Audit Application
- About the Audit Trail Application
- A Few Limitations
- Tracking Inserts
- The First Sequence Creation Script (SEQ-RID)
- The First Trigger Creation Script (Before-Insert)
- Tracking Updates and Deletions
- The Three Table Creation Scripts
- The Second Sequence Creation Script (SEQ_AUDIT)
- The Second Trigger Creation Script (After-Update)
- The Third Trigger Creation Script (After-Delete)
- The Package and Procedure Creation Scripts
- About Performance and Storage
- Using the Audit Data in Reports
- SQL Scripts to Generate Scripts
- About the Audit Trail Application
- 12. Backing Up and Recovering the Database
- 13. Using the Oracle Enterprise Manager
- 14. Maintaining User Accounts
- III. Enhanced Oracle Security
- 15. Using the Oracle Security Server
- 16. Using the Internet and the Web
- 17. Using Extra-Cost Options
- A. References
- Index
- Colophon
Please address comments and questions concerning this book to the publisher:
| O’Reilly & Associates, Inc. |
| 101 Morris Street |
| Sebastopol, CA 95472 |
| 800-998-9938 (in the U.S. or Canada) |
| 707-829-0515 (international or local) |
| 707-829-0104 (fax) |
You can also send us messages electronically. For corrections and amplifications for the book, as well as for copies of the scripts found in this book, check out http://www.oreilly.com/catalog/orasec. See the ads at the end of the book for information about all of O’Reilly & Associates’ online services.
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.