O'Reilly logo

Oracle PL/SQL in 10 Minutes, Sams Teach Yourself by Ben Forta

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Lesson 26. Managing Security

Database servers usually contain critical data, and ensuring the safety and integrity of that data requires that access control be used. In this lesson, you’ll learn about Oracle access control and user management.

Understanding Access Control

The basis of security for your Oracle server is this: Users should have appropriate access to the data they need—no more and no less. In other words, users should not have too much access to too much data.

Consider the following:

Image Most users need to read and write data from tables, but few users will ever need to be able to create and drop tables.

Some users might need to read ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required