Search This Blog

Total Pageviews

Thursday, 1 September 2022

ORA-65049: Creation of local user or role is not allowed in this container.



ORA-65049: Creation of local user or role is not allowed in this container


grant dba to test identified by teast123
*
ERROR at line 1:
ORA-65049: Creation of local user or role is not allowed in this container.

################################################################################################



alter session set "_ORACLE_SCRIPT"=true;


grant dba to test identified by teast123;

Grant succeeded.  <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<  Created 


col USERNAME for a20
set linesize 300 pagesize 300
select USERNAME,COMMON from dba_users ;


USERNAME                       COM
------------------------------ ---
TEST                           YES



Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.14.0.0.0

SQL> create user c##test identified by test123 container=all;  otherwise create c## user 

User created.



USERNAME             COM
-------------------- ---
C##TEST              YES

Oracle DBA

anuj blog Archive