Database Administration (MOSC)

MOSC Banner

Getting ORA-01922 while dropping user with only select privileges granted

Hi Experts,

We had created a database user a while back that was given just a few privileges to read a table and MV. We would now like to remove the user, since it is no longer needed by the requesting team. However, I am getting "ORA-01922" when trying to drop without specifying the cascade option.

Hoping to understand why this is happening, as this user should not own anything (and, we do not want the "granted" objects to be removed).

Drop user failing:

SQL> drop user NPA_HWA_ID01;
drop user NPA_HWA_ID01
*
ERROR at line 1:
ORA-01922: CASCADE must be specified to drop 'NPA_HWA_ID01'

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center