DB version:19c
OS : RHEL 7.9
I have created the common user C##RMAN_USER with CONTAINER = ALL clause.
Now, when connected from the root container, I try to run the below ALTER USER command. But, it fails until I add CONTAINER=CURRENT clause.
Any idea what ORA-65273 mean ? I am new to multitenant world.
create user C##RMAN_USER identified by Tigress384 CONTAINER = ALL; --- This was successful
SQL> ALTER USER C##RMAN_USER PROFILE UNLIMITED_CUST1 SET container_data = ALL;
ALTER USER C##RMAN_USER PROFILE UNLIMITED_CUST1 SET container_data = ALL
*
ERROR at line 1:
ORA-65273: The specified changes must be restricted to the current container.
ALTER USER C##RMAN_USER
PROFILE UNLIMITED_CUST1
SET container_data = ALL
4 CONTAINER=CURRENT;
User altered.
SQL>
SQL> show con_name
CON_NAME
------------------------------
CDB$ROOT