CHAPTER7Privileges and Roles

This chapter discusses database privileges and roles. Understanding privileges and how they can be granted is important to employing effective security. Roles allow administrators to grant users the necessary privileges needed to perform their job. Roles are a powerful and manageable way to provide a least-privileged environment, which is important to ensuring a sound and secure database.

The intent of this chapter is not to duplicate the Oracle product documentation, which discusses both privileges and roles. The objective here is to point out some of the important and subtle aspects that are associated with privileges and roles. This is a very important chapter because database access, and to a large extent database ...

Get Effective Oracle Database 10g Security by Design now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.