My Oracle Support Banner

Roles and Privileges Administration and Restrictions (Doc ID 13615.1)

Last updated on MARCH 10, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 8.1.7.4 and later
Information in this document applies to any platform.
Checked for relevance on 17-Oct-2012


Purpose

This article seeks to give a general overview of the roles and privileges functionality for the Oracle RDBMS. It delineates advantages and limitations of administering privileges through roles. The effects of granting and revoking roles are analyzed and important authorization and security issues are discussed.

Scope

This article is intended to assist all Oracle DBAs who need to administer security on the database. All of the points covered in this article are applicable to currently supported Oracle RDBMS versions. Some newer features like secure application roles remain undiscussed, however all the topics covered in this article are valid for the current releases and remain important as a conceptual background.

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.