--when we drop a user casecade, the role created by the user will not be --droped with the user. Hence we need this script to drop the role --first in case they existed due to reuse a dropped user name later --DROP ROLE %owb_user_role; DROP ROLE %view_public_role;