About this series
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
Titles in the series (4)
- Oracle Quick Guides: Part 1 - Oracle Basics: Database and Tools
1
This is Part 1 of a series of quick learning guides for Oracle designers, developers and managers. It introduces completely new entrants to the Oracle environment: Relational principles, history, background of Oracle, the products, database architecture, installation, Oracle and 3rd party database and design tools and includes a glossary of basic Oracle terms and explanations of their meaning. These guides are designed to rapidly deliver key information about Oracle to the following audience groups: - Project Managers, Team Leaders, Testers who are new to Oracle and need rapid access to strategic information about the Oracle development environment. - Business Analysts, Designers, Developers who are new to Oracle and need to make first steps in gaining a detailed understanding of the design and development issues involved in Oracle. Part 1 assumes that the reader has no knowledge of Oracle. The contents of Part 1 include the following: 1. Oracle - A Brief History. 2. Relational databases: An introduction. 3. How relational databases impact software development. 4. Basic descriptions of Oracle products. 5. The Oracle database architecture. 6. Tools: Oracle's own design / development tools. 7. Implementing Oracle DB and Oracle tools - Overview. 8. Various 3rd Party Tools: Quick review. 9. Glossary
- Oracle Quick Guides: Part 2 - Oracle Database Design
2
This is Part 2 of a series of quick learning guides for Oracle designers, developers and managers. Part 2 introduces completely new entrants to concepts of Oracle database analysis and design, database normalisation, the logical datamodel, E-R modelling and diagrams, logical to physical transformation in Oracle Designer, physical database design, de-normalization, database design for performance, and building a physical database from a server model. These guides are designed to rapidly deliver key information about Oracle to the following audience groups: - Project Managers and Team Leaders who are new to Oracle and need rapid access to strategic information about the Oracle design and development environment. - Business Analysts, Designers and Software developers who are new to Oracle and need to make first steps in gaining a detailed understanding of the design and development issues involved in Oracle. Part 2 assumes that the reader has a basic knowledge of the relational model and a basic understanding of logical and physical design concepts. The contents of Part 2 include the following subject headings: Preface and Audience 1. The Analysis phase - Separating Functional and Database Design 2. Introduction to Datamodelling and Database Design: Logical and Physical concepts of design 3. Practical Logical Design - Data-modelling 4. Practical Logical Design using Oracle Designer 5. Moving from the Logical to the Physical design 6. Practical Physical Design (using Oracle Designer) 7. Designing a database for Performance 8. Building the physical database from Designer 9. Managing Changes during development 10. Glossary of Terms
- Oracle Quick Guides: Part 3 - Coding in Oracle: SQL and PL/SQL
3
This is Part 3 of a series of quick learning guides for Oracle designers, developers and managers. Part 3 introduces completely new entrants to the main concepts of the SQL language and to the use and development of Oracle's PL/SQL procedural version of SQL. The guide includes details of how to install and use a SQL*Plus client and the basic use of Oracle's SQL Developer tool. The guide also provides a foundation in coding practise in SQL and PL/SQL with some basic guidelines for good practise in coding and managing SQL and PL/SQL software performance issues. Part 3 also contains a glossary of Oracle terminology related to SQL and PL/SQL 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, Team Leaders, and Testers who are new to Oracle and need rapid access to strategic information about the Oracle development environment. - Business Analysts, Designers and Software developers who are new to Oracle and need to make a first step in gaining a detailed understanding of the design and development issues involved in Oracle. Part 3 assumes that the reader has read Parts 1 and 2 of the Oracle Quick Guides or their equivalent content. The contents of Part 3 include the following subject headings: 1. What are SQL, SQL*Plus and PL/SQL? 2. Basic Components of SQL. 3. Basic SQL Language Syntax. 3.1 SQL Language Elements. 3.2 SQL Operators 3.3 SQL Expressions 3.4 SQL Functions 3.5 SQL Clauses 3.6 SQL Query syntax. 3.7 SQL Data Modification Language syntax (DML). 3.8 SQL Data Definition Language syntax (DDL). 3.9 SQL Data Command Language syntax (DCL). 3.10 SQL Data Types in Oracle 4. Complex SQL constructs: Understanding Joins. 5. Understanding Commit and Rollback. 6. Basic architecture PL/SQL Procedures, Functions and Triggers. 7. Basic PL/SQL Language syntax. 8. PL/SQL Exception handling. 9. SQL and PL/SQL: some standards for good coding appearance. 10. Performance issues when coding in SQL 11. Installing and using a SQL*Plus client 12. SQL - PL/SQL Development Tools 13. Glossary of Terms.
- Oracle Quick Guides: Part 4 - Oracle Administration: Security and Privilege
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
Malcolm Coxall
Malcolm Coxall is a management consultant, systems analyst, organic farmer and author, with more than 30 years experience working for many of the world's largest corporate and institutional organisations, starting in the field of dispute arbitration for the ILO. These experiences have provided him a ringside view of the management methodologies used by medium and large businesses in areas as diverse as banking, oil, defence, telecoms, insurance, manufacturing, mining, food, agriculture, aerospace, textiles, and heavy engineering. Malcolm has published articles on political science, sociology, human design, sustainable agriculture, organic food production, technology in organic farming, biodiversity, forest management, environmental protection and environmental economics. He is active in European environmental politics and was a successful private complainant in the European Court of Justice in several cases of national breaches of European environmental law. He now lives in Southern Spain from where he continues his IT and system consultancy work, writing and managing the family's organic olive farm.
Read more from Malcolm Coxall
Human Manipulation: A Handbook Rating: 0 out of 5 stars0 ratingsMachiavellian Management: A Chief Executive's Guide Rating: 0 out of 5 stars0 ratingsCivil Disobedience: A Practical Guide Rating: 1 out of 5 stars1/5Ethical Eating: A Complete Guide to Sustainable Food Rating: 0 out of 5 stars0 ratings
Related to Oracle Quick Guides
Related ebooks
The Grand Canyon of Arizona; how to see it Rating: 0 out of 5 stars0 ratingsCracking the Wine Code: Your Guide To Herbal Winemaking For Longevity and Life Extension: HealingUTrust Optimal Health, #1 Rating: 0 out of 5 stars0 ratingsBusiness Heroes - worldwide: Helden für den Mittelstand - weltweit Rating: 0 out of 5 stars0 ratingsMessages from the Heart of Love - Spirituality Basics in 144 Empowering Quotes Rating: 0 out of 5 stars0 ratingsOrbit: Mark Zuckerberg, Creator of Facebook Rating: 0 out of 5 stars0 ratingsRock and Roll Comics: Elvis Presley Experience Rating: 5 out of 5 stars5/5globo arte october issue 2021 Rating: 0 out of 5 stars0 ratingsOn the Way Rating: 0 out of 5 stars0 ratingsThe Way of Courage Rating: 0 out of 5 stars0 ratingsThe Christmas Fish Rating: 0 out of 5 stars0 ratingsEarth-Sod-Blen Rating: 0 out of 5 stars0 ratings15 Minutes: Kim Kardashian Rating: 0 out of 5 stars0 ratingsTom Corbett: Space Cadet: Classic Edition #8 Rating: 0 out of 5 stars0 ratingsGabriel: The Shattered Star Rating: 0 out of 5 stars0 ratingsThe Itsy and Bitsy Birdie Book Rating: 0 out of 5 stars0 ratingsRoo and the World of Crum Rating: 0 out of 5 stars0 ratingsLegend of Isis #6: Volume 2 Rating: 0 out of 5 stars0 ratingsFemale Force: RuPaul Rating: 0 out of 5 stars0 ratingsWhitetail Deer Facts and Strategies Rating: 0 out of 5 stars0 ratingsThe Runaway Knight Rating: 0 out of 5 stars0 ratingsOMWG Oh, My Wonderful God!: A Tribute in Verse to Our Lord and Savior Rating: 0 out of 5 stars0 ratingsFAME: Pop Stars #1 Rating: 0 out of 5 stars0 ratingsRuth & Freddy #4 Rating: 0 out of 5 stars0 ratingsLegend of Isis Gallery #2 Rating: 0 out of 5 stars0 ratingsOrbit: The Cast of Doctor Who #1 Rating: 5 out of 5 stars5/5Nuggets for the Soul: Poems That Will Inspire You Rating: 0 out of 5 stars0 ratingsThe Muse #1 Rating: 0 out of 5 stars0 ratingsVincent Price Presents #04 Rating: 0 out of 5 stars0 ratingsStrangers' Voices In My Head: A Journey Through What Made Me Who I Am from My Mind Rating: 0 out of 5 stars0 ratingsBehind the Scenes at Sega: The Making of a Video Game Rating: 0 out of 5 stars0 ratings
Databases For You
Grokking Algorithms: An illustrated guide for programmers and other curious people Rating: 4 out of 5 stars4/5Access 2019 For Dummies Rating: 0 out of 5 stars0 ratingsBlockchain Basics: A Non-Technical Introduction in 25 Steps Rating: 5 out of 5 stars5/5SQL QuickStart Guide: The Simplified Beginner's Guide to Managing, Analyzing, and Manipulating Data With SQL Rating: 4 out of 5 stars4/5Learn SQL in 24 Hours Rating: 5 out of 5 stars5/5100+ SQL Queries T-SQL for Microsoft SQL Server Rating: 4 out of 5 stars4/5Python Projects for Everyone Rating: 0 out of 5 stars0 ratingsPractical Data Analysis Rating: 4 out of 5 stars4/5Learn SQL Server Administration in a Month of Lunches Rating: 3 out of 5 stars3/5Access 2016 For Dummies Rating: 0 out of 5 stars0 ratingsSQL Clearly Explained Rating: 5 out of 5 stars5/5Artificial Intelligence for Fashion: How AI is Revolutionizing the Fashion Industry Rating: 0 out of 5 stars0 ratingsCOMPUTER SCIENCE FOR ROOKIES Rating: 0 out of 5 stars0 ratingsText Analytics with Python: A Practitioner's Guide to Natural Language Processing Rating: 0 out of 5 stars0 ratingsBeginning Microsoft Power BI: A Practical Guide to Self-Service Data Analytics Rating: 0 out of 5 stars0 ratingsCOBOL Basic Training Using VSAM, IMS and DB2 Rating: 5 out of 5 stars5/5Developing High Quality Data Models Rating: 0 out of 5 stars0 ratingsData Governance: How to Design, Deploy and Sustain an Effective Data Governance Program Rating: 4 out of 5 stars4/5Building a Scalable Data Warehouse with Data Vault 2.0 Rating: 4 out of 5 stars4/5Business Intelligence Strategy and Big Data Analytics: A General Management Perspective Rating: 5 out of 5 stars5/5SQL Server: Tips and Tricks - 2 Rating: 4 out of 5 stars4/5Serverless Architectures on AWS, Second Edition Rating: 5 out of 5 stars5/5Query Store for SQL Server 2019: Identify and Fix Poorly Performing Queries Rating: 0 out of 5 stars0 ratingsMicrosoft SQL Server 2008 All-in-One Desk Reference For Dummies Rating: 0 out of 5 stars0 ratingsVisual Basic 2010 Coding Briefs Data Access Rating: 5 out of 5 stars5/5Oracle DBA Mentor: Succeeding as an Oracle Database Administrator Rating: 0 out of 5 stars0 ratingsData Mining: Concepts and Techniques Rating: 4 out of 5 stars4/5
Related categories
Reviews for Oracle Quick Guides
0 ratings0 reviews