I was trying to drop a user but couldn’t as it had QUEUE tables, queue rule andrule-set. So it required to drop ruleset before dropping the user.
I tried the following and failed with a misleading error.
I kept searching how to drop subscriber, but nothing worked.
Here is the solution that worked:
1.Set the following event at session level:
2. Drop rule:
3.Drop rule set :
4. Connect as SYSTEM or SYSDBA and try to drop user again.
drop user cascade;