Fundamentals ii oracle 11g

Fundamentos II
Material Adicional
D49994GC11
Edición 1.1
05 2009
Oracle Database 11g: SQL
Fundamentals II
Additional Material
D49994GC11
Edition 1.1
May 2009

Copyright © 2009, Oracle. All rights reserved.

Disclaimer

This course provides an overview of features and enhancements planned in release 11g. It is intended solely to help you assess the business benefits of upgrading to11g and to plan your IT projects.

This course in any form, including its course labs and printed matter, contains
proprietary information that is the exclusive property of Oracle. This course and the
information contained herein may not be disclosed, copied, reproduced, or distributed to anyone outside Oracle without prior written consent of Oracle. This course and its contents are not partof your license agreement nor can they be incorporated into any contractual agreement with Oracle or its subsidiaries or affiliates.

This course is for informational purposes only and is intended solely to assist you in planning for the implementation and upgrade of the product features described. It is not a commitment to deliver any material, code, or functionality, and should not be reliedupon in making purchasing decisions. The development, release, and timing of any features or functionality described in this document remain at the sole discretion of Oracle.

This document contains proprietary information and is protected by copyright and
other intellectual property laws. You may copy and print this document solely for your own use in an Oracle training course. The document maynot be modified or altered in any way. Except where your use constitutes "fair use" under copyright law, you may not use, share, download, upload, copy, print, display, perform, reproduce, publish, license, post, transmit, or distribute this document in whole or in part without the express authorization of Oracle.

The information contained in this document is subject to change without notice.If
you find any problems in the document, please report them in writing to: Oracle University, 500 Oracle Parkway, Redwood Shores, California 94065 USA. This document is not warranted to be error-free.

Restricted Rights Notice
If this documentation is delivered to the United States Government or anyone using
the documentation on behalf of the United States Government, the following noticeis applicable:

U.S. GOVERNMENT RIGHTS

The U.S. Government’s rights to use, modify, reproduce, release, perform, display, or disclose these training materials are restricted by the terms of the applicable Oracle license agreement and/or the applicable U.S. Government contract.

Trademark Notice

Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other
names maybe trademarks of their respective owners.

Authors
Chaitanya Koratamaddi
Brian Pottle
Technical Contributors
and Reviewers
Claire Bennett
Ken Cooper
Yanti Chang
Laszlo Czinkoczki
Burt Demchick
Gerlinde Frenzen
Joel Goodman
Laura Garza
Richard Green
Nancy Greenberg
Akira Kinutani
Wendy Lo
Isabelle Marchand
Timothy Mcglue
Alan Paulson
Srinivas Putrevu
Bryan Roberts
ClintonShaffer
Abhishek Singh
Jenny Tsai Smith
James Spiller
Lori Tritz
Lex van der Werff
Marcie Young
Editors
Nita Pavitran
Arijit Ghosh
Raj Kumar
Graphic Designer
Satish Bettegowda
Publishers
Syed Ali
Jayanthy Keshavamurthy

Contents

1 Controlling User Access
Objectives 1-2
Lesson Agenda 1-3
Controlling User Access 1-4
Privileges 1-5
System Privileges 1-6
Creating Users 1-7User System Privileges 1-8
Granting System Privileges 1-9
Lesson Agenda 1-10
What Is a Role? 1-11
Creating and Granting Privileges to a Role 1-12
Changing Your Password 1-13
Lesson Agenda 1-14
Object Privileges 1-15
Granting Object Privileges 1-17
Passing On Your Privileges 1-18
Confirming Granted Privileges 1-19
Lesson Agenda 1-20
Revoking Object Privileges 1-21
Quiz 1-23
Summary...