WebMar 28, 2015 · old 1: drop user &APPUN cascade new 1: drop user APEX_040200 cascade drop user APEX_040200 cascade * ERROR at line 1: ORA-28014: cannot drop administrative users Is there a solution? Added on Mar 28 2015 #apex-discussions 8 … WebIn a standard database this is done using the following command: DROP USER APEX_200100 CASCADE; However in a multi-tenant database this command returns the following error: SQL> drop user apex_200100 cascade; drop user apex_200100 cascade * ERROR at line 1: ORA-28014: cannot drop administrative users
ORA-28014: cannot drop administrative users ~ Sultandba blog for oracle …
WebApr 14, 2024 · -- -- drop the Oracle Maintained user APEX_INSTANCE_ADMIN_USER -- alter session set "_ORACLE_SCRIPT"=true; drop user APEX_INSTANCE_ADMIN_USER; alter session set "_ORACLE_SCRIPT"=false; -- -- recreate APEX_INSTANCE_ADMIN_USER as a non Oracle Maintained user -- create user apex_instance_admin_user no authentication; grant … WebMay 17, 2024 · An alternative way to drop a user in dbForge Studio for Oracle is by deleting it using Security Manager: 1. Select Security Manager on the Database menu. 2. Choose … irc richmond
Oracle 19cR1 ORA-28014 cannot drop administrative users
WebError code: ORA-28014 Description: cannot drop administrative users Cause: An attempt was made to drop administrative users. Administrative users can be dropped only by SYS during migration mode. Action: Try dropping administrative users during migration mode. Database: 12c Release 2 Error code: ORA-28014 WebFeb 15, 2024 · 1 CREATE PLUGGABLE DATABASE ADMIN USER Use this clause to create an administrative user who can be granted the privileges required to perform administrative tasks on the PDB. For admin_user_name, specify name of the user to be created. Use the IDENTIFIED BY clause to specify the password for admin_user_name. WebPROBLEM: While dropping APEX user got below error in oracle 12c, got below error. SQL> drop user APEX_050000 cascade; drop user APEX_050000 cascade * ERROR at line 1: ORA-28014: cannot drop administrative users SOLUTION: set _oracle_script to TRUE and execute drop command as below. order cake online canada