hi guys, i've been nowhere to found reason why i can't drop this role to the database. can anyone enlighten me to troubeshoot this issue. do i still need to drop users for that role(dummy_role). or is it ok to drop the role with override option.


The role 'dummy_role' was not dropped because it still has privilege granted to it. Use the 'WITH OVERRIDE' option to drop it