Skip to content

ORA-28014: cannot drop administrative users

SYMPTOMS

While trying to drop an user in a multitenant database the following error is seen:

 

SQL> drop user <user> cascade;
drop user <user> cascade
*
ERROR at line 1:
ORA-28014: cannot drop administrative users

 

Creating users via catcon.pl and then trying to drop them directly in sqlplus results in ORA-28014.

CAUSE

The user was created by a script executed via catcon.pl. The users created this way are considered administrative users since in that session the parameter “_oracle_script” is set to TRUE.

SOLUTION

Avoid creating users by running a script via catcon.pl. If the users must be dropped then drop them via catcon.pl as well or set “_oracle_script” to TRUE before dropping the users directly:

 

SQL> alter session set “_oracle_script”=true;

Session altered.

SQL> drop user <user> cascade;

User dropped.

 

Note: Be careful when dropping users this way. Some of the users might have been indeed created by scripts supplied by Oracle and might be needed for the components running inside that pluggable database.
No comments yet

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: