My Oracle Support Banner

ORA-28405 Cannot Grant Secure Role To Another Role (Doc ID 1994408.1)

Last updated on FEBRUARY 28, 2019

Applies to:

Oracle Database - Standard Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

A secure role is either a password protected role or a secure application role. In rdbms 12c (and backported to patchset 11.2.0.4), granting a secure role to a non-secure role results in error -> ORA-28405 "cannot grant secure role to a role", this worked in 11g.

Similarly, if non-secure role X has been already granted to non-secure role Y and you try to add a password to role X, you will receive the error ORA-28404 "role cannot be altered"

Changes

 Upgrade to 12c

Cause

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

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


In this Document
Symptoms
Changes
Cause
Solution
References


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