Alter user gives error: ORA-65066: The specified changes must apply to all containers
(Doc ID 2110261.1)
Last updated on JUNE 27, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.1 to 12.2.0.1 [Release 12.1 to 12.2]Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
On 12c, in a Oracle Multitenant environment, attempting to change an Oracle common user in the PDB results in the following error
SQL> alter user SPATIAL_WFS_ADMIN_USR identified by ABC123;
alter user SPATIAL_WFS_ADMIN_USR identified by ABC123
*
ERROR at line 1: ORA-65066: The specified changes must apply to all containers
If we modify the SQL statement to include "container=all" we now get the following error
SQL> alter user SPATIAL_WFS_ADMIN_USR identified by ABC123 container=all;
alter user SPATIAL_WFS_ADMIN_USR identified by SPATIAL_WFS_ADMIN_USR container=all
*
ERROR at line 1:
ORA-65050: Common DDLs only allowed in CDB$ROOT
An Oracle common user is one that is installed with the database and is present in the CDB root (CDB$ROOT). Typical Oracle users would be CTXSYS, ORDSYS, MDSYS and SYSMAN.
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 |
Cause |
Solution |
References |