ORA-1922 when dropping user
stuartuNov 24 2009 — edited Jun 13 2013I'm trying to get rid of an old database user account on our Production database that was used for dba work. I've removed all objects and grants, but it keeps coming up with ORA-1922 when I try and 'drop user <user>', and that I should be doing drop cascade.
Is anyone able to advise what object Oracle might be complaining about? Yes, I could just disable the account, or run with a cascade, but I want to get rid of this account, and I want to know I've covered all objects (we transferred them to another schema) and drop without cascade.
PROD: SYS AS SYSDBA> select owner, object_name, object_type from all_objects where owner = 'OPS$CTRU_DBA';
no rows selected
PROD: SYS AS SYSDBA> select * from dba_role_privs where grantee = 'OPS$CTRU_DBA';
no rows selected
PROD: SYS AS SYSDBA> select * from dba_sys_privs where grantee = 'OPS$CTRU_DBA';
no rows selected
PROD: SYS AS SYSDBA> select * from dba_tab_privs where grantee = 'OPS$CTRU_DBA';
no rows selected
PROD: SYS AS SYSDBA> drop user ops$ctru_dba;
drop user ops$ctru_dba
*
ERROR at line 1:
ORA-01922: CASCADE must be specified to drop 'OPS$CTRU_DBA'