Oracle Quick Guides Part 4 - Oracle Administration: Security and Privilege

Oracle Quick Guides Part 4 - Oracle Administration: Security and Privilege

by Malcolm Coxall, Guy Caswell

NOOK Book(eBook)

$3.04 View All Available Formats & Editions

Available on Compatible NOOK Devices and the free NOOK Apps.
WANT A NOOK?  Explore Now
LEND ME® See Details


This is Part 4 of a series of quick learning guides for Oracle administrators, designers, developers and managers. Part 4 introduces early entrants with basic Oracle skills to the main concepts of Oracle data security and user privilege management and administration.

The guide includes details of how to create and how to manage users and their database object and system access and rights. The guide also provides a basis for understanding different database security strategies such as role-based security, virtual private databases and procedure-based security.

Part 4 contains a glossary of Oracle terminology related to database security and user privilege administration with clear explanations of the terms used.

These guides are designed to rapidly deliver key information about Oracle to the following audience groups:

- Project Managers, Database Administrators, Team Leaders, and Testers who are new to Oracle and need rapid access to strategic information about the Oracle security environment in both development and production databases.

- Business Analysts, Software Designers and Developers who are new to Oracle and need to gain a detailed understanding of the data security and administration issues involved in an Oracle database.

Part 4 of these guides assumes that the reader has read Parts 1, 2 and 3 of the Oracle Quick Guides or their equivalent content. The contents of Part 4 include the following subject headings:

1. Oracle Database Security Architecture
2. Managing Oracle User Security
3. Managing Privileges and Roles
4. Managing Resources with Profiles
5. Managing Passwords with Profiles
6. Special Users and Privileges - SYS, SYSTEM, SYSDBA, SYSOPER
7. Managing Developer Security
8. Virtual Private Databases (VPD)
9. Procedure Execution Security
10. Data Security using Views
11. Tool Security - PRODUCT_USER_PROFILE Table
12. Obtaining Security Information from the Data Dictionary
13. Glossary of Terms
Appendix 1 - Common System Privileges
Appendix 2 - SYSDBA and SYSOPER Privileges
Appendix 3 - SQL commands which can be disabled

Product Details

BN ID: 2940157633684
Publisher: Malcolm Coxall
Publication date: 04/07/2016
Series: Oracle Quick Guides , #4
Sold by: Barnes & Noble
Format: NOOK Book
Pages: 90
File size: 232 KB

About the Author

Malcolm Coxall, the author, is a business and IT systems analyst and consultant with more than 30 years freelance experience in Europe and the Middle East. Malcolm has worked in Oracle systems design and development for the last 25 years as a developer, business analyst, database designer, DBA, systems administrator, team lead and project manager. With experience working for many of the world's largest corporate and institutional players, as well as for several government and international agencies, Malcolm has extensive hands-on experience in designing and building large-scale Oracle systems in many diverse vertical markets such as banking, oil, defence, telecoms, manufacturing, mining, food, agriculture, aerospace, and engineering. Malcolm also writes and publishes books, papers and articles on human system design, sociology, environmental economics, sustainable technology and technology in environmental protection and food production. Malcolm's company designed and built the Oracle systems known as BioTrack and EcoBase. BioTrack is an integrated agriculture and food production control and traceability system designed specifically for organic and other specially controlled food production industries. EcoBase is an environmental research database for bringing together environmental data with complex statistical analysis techniques. Both of these systems were designed and developed in Oracle 10g and are commercialised as cloud-based systems directly available to end-users. Malcolm lives in southern Spain from where he continues his free-lance Oracle consultancy and his writing, whilst managing the family's organic farm.

Customer Reviews