Drop role not working, it hangs.

[tekpr00]

Hello All,

Drop Role is not working for me. It hangs:

drop role CALLCHK_USER cascade ;
drop role CALLIGO_USER cascade;

The above statements just hang without error output.
Any input will be appreciated.
I am thinking I need to temporarily disable a constraint.
How to identify which constraints to disable.
I cannot disable all as this is a working database.

 

[johnherman]

Just a hypothesis: A user or process is using that Role. Try dropping the Role when only DBA has access, like just after a restart.

==================================
advanced cognitive capabilities and other marketing buzzwords explained with sarcastic simplicity

 

[Beilstwh]

You should be able to drop a role while users are logged on. However the correct commands are

drop role CALLCHK_USER;
drop role CALLIGO_USER;

Get rid of the cascade

Bill
Lead Application Developer
New York State, USA