\set user_suffix _user
DROP SCHEMA :v1 cascade;
REVOKE ALL PRIVILEGES ON DATABASE :v2 FROM :v1:user_suffix;
REVOKE ALL PRIVILEGES ON SCHEMA pgtt_schema FROM :v1:user_suffix;
REVOKE EXECUTE ON PACKAGE SYS.UTL_FILE FROM :v1:user_suffix;
REVOKE EXECUTE ON PACKAGE SYS.UTL_SMTP FROM :v1:user_suffix;
REVOKE EXECUTE ON PACKAGE SYS.UTL_TCP FROM :v1:user_suffix;
REVOKE SELECT ON DBA_USERS FROM :v1:user_suffix;
DROP USER :v1:user_suffix;
