Last updated on NOVEMBER 29, 2016
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 to 18.104.22.168 [Release 12.1]
Information in this document applies to any platform.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms