Murach's Oracle SQL and PL/SQL
How to manage database security

This chapter shows you how to configure security for an Oracle system using SQL statements and SQL Developer.
Chapter 12 How to manage database security
An introduction to database security 370
How to create an admin user 370
How to use SQL Developer to view database objects for a schema 372
How to create end users 374
How to use SQL*Plus to test end users 376
Systems privileges and object privileges 378
How to manage database security 380
How to create, alter, and drop users 380
How to create and drop roles 382
How to grant privileges 384
How to revoke privileges 386
How to work with private synonyms 388
How to work with public synonyms 390
A script that creates roles and users 392
How to view the privileges for users and roles 396
How to use SQL Developer 398
How to work with users 398
How to grant and revoke roles 400
How to grant and revoke system privileges 402


© Copyright 1998-2009 Mike Murach & Associates, Inc.  All rights reserved.

Murach's Oracle SQL and PL/SQL

Learn more about this book

View the table of contents

Add this book to your cart



Our Ironclad Guarantee

First, try our books for 90 days. Then, if you aren't completely convinced that our books are the best ones you've ever used, you can return them for a full refund...no questions asked.