ORA-28405 Cannot Grant Secure Role To Another Role
Last updated on DECEMBER 06, 2016
Applies to:Oracle Database - Standard Edition - Version 22.214.171.124 and later
Information in this document applies to any platform.
A secure role is either a password protected role or a secure application role. In rdbms 12c (and backported to patchset 126.96.36.199), 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"
Upgrade to 12c
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 hundreds of Community platforms