Menu
I am not able to drop a user created by me which has administrative rights.
I am running below command:
drop user GOVIND CASCADE;
This is the error I am getting:
ERROR at line 1:
ORA-28014: cannot drop administrative users
998
For dropping the user present in Container ROOT, we need to use the hidden parameter “_ORACLE_SCRIPT”. SQL> alter session set "_oracle_script"=true; Session altered.
You must have the DROP USER system privilege. Specify the user to be dropped. Oracle Database does not drop users whose schemas contain objects unless you specify CASCADE or unless you first explicitly drop the user's objects. Specify CASCADE to drop all objects in the user's schema before dropping the user.
Cause: An attempt was made to drop a user that was currently logged in. Action: Make sure the user is logged out, then re-execute the command. The ORA-01940 can always be cured by bouncing the source and replicated instance. First, double-check to ensure that the user is not connected to the current instance.
Show activity on this post. BEGIN FOR c IN (SELECT table_name FROM user_tables) LOOP EXECUTE IMMEDIATE ('DROP TABLE "' || c. table_name || '" CASCADE CONSTRAINTS'); END LOOP; FOR s IN (SELECT sequence_name FROM user_sequences) LOOP EXECUTE IMMEDIATE ('DROP SEQUENCE ' || s.
set _oracle_script to TRUE and execute drop command as below.
alter session set "_oracle_script"=true;
Session altered
drop user APEX_050000 cascade;
User dropped.
85
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With