Oracle7 Server Administrator's Guide

CHAPTER 20. Managing User Privileges and Roles

This chapter explains how to control the capability to execute system operations and access to schema objects using privileges and roles. The following topics are included:

Identifying User Privileges

Managing User Roles

Granting User Privileges and Roles

Revoking User Privileges and Roles

Granting Roles Using the Operating System or Network

Listing Users' Privilege and Role Information

See Also: For information about controlling access to a database, see Chapter 19.

For suggested general database security policies, see Chapter 18.

If you are using Trusted Oracle7 in DBMS MAC mode, see the Trusted Oracle7 Server Administrator's Guide for important information about system privileges and role management.

This chapter contains several references to Oracle Server Manager. For more information about performing specific tasks using Server Manager/GUI or Server Manager/LineMode, see the Oracle Server Manager User's Guide.