ORA-65067
Cause
An attempt was made to reference a local role across all containers using the DEFAULT ROLE clause.
Action
Review the Oracle Database documentation for the ALTER USER statement. Also, review the CONTAINER clause to see the default settings in a pluggable database (PDB) and the multitenant container database (CDB) root. If you are trying to set a local role as the default role, then specify CONTAINER=CURRENT since a local role cannot be set as a default role in every container.
Additional Information
If you are trying to set a list of roles in the DEFAULT ROLE
clause, then you may need to break them out separately into
two commands; one command with local and common roles specifying
CONTAINER=CURRENT
and another command specifying common roles
only with CONTAINER=ALL
.
The command for local and common roles is:
ALTER USER DEFAULT ROLE <localrole1, commonrole1> CONTAINER=CURRENT;
The command for common roles only is:
ALTER USER DEFAULT ROLE <commonrole2, commonrole3> CONTAINER=ALL;