\ud83d\ude0e To create a sysdba user that can administrate all containers:<\/p>\n
\r\n\r\nsys@ORCL> show con_id\r\n\r\nCON_ID\r\n------------------------------\r\n1\r\nsys@ORCL> show con_name\r\n\r\nCON_NAME\r\n------------------------------\r\nCDB$ROOT\r\n \r\nsys@ORCL> create user c##username identified by <password>;\r\n\r\nUser created.\r\n\r\nsys@ORCL> grant create session to c##username;\r\n\r\nGrant succeeded.\r\n\r\nsys@ORCL> grant sysdba to c##username container = ALL;\r\n\r\nGrant succeeded.\r\n<\/pre>\nIf it is necessary to change the common user prefix (or get rid of it!), the value of _common_user_prefix_common_user_prefix can be changed:<\/p>\n
\r\nsys@ORCL> select rpad(ksppinm,40) ||' ----> '||ksppstvl "param, value" from x$ksppi a,x$ksppsv b\r\n 2 where a.indx=b.indx and substr(ksppinm,1,1) = '_' and ksppinm like '%common%';\r\n\r\nparam, value\r\n_ksipc_common_sl ---->\r\n_eliminate_common_subexpr ----> TRUE\r\n_dump_common_subexpressions ----> FALSE\r\n_common_data_view_enabled ----> TRUE\r\n_common_user_prefix ----> C##\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"Oracle – Multitenant – Create a sysdba Common User \ud83d\ude0e To create a sysdba user that can administrate all containers: sys@ORCL> show con_id CON_ID —————————— 1 sys@ORCL> show con_name CON_NAME —————————— CDB$ROOT sys@ORCL> create user c##username identified by <password>; User … Continue reading