Postgres: To revoke redeveloper access from coupon database

 

revoke select on cpnadmin.databasechangeloglock from gp120;

revoke select on cpnadmin.databasechangelog from gp120;

revoke select on cpnadmin.brands from gp120;

revoke select on cpnadmin.coupon_types from gp120;

revoke select on cpnadmin.channels from gp120;

revoke select on cpnadmin.promotion_types from gp120;

revoke select on cpnadmin.vendors from gp120;

revoke select on cpnadmin.offers from gp120;

revoke select on cpnadmin.coupons from gp120;

revoke select on cpnadmin.customer_coupons from gp120;

revoke select on cpnadmin.channels_vendors from gp120;

revoke select on cpnadmin.users_audit from gp120;

revoke select on cpnadmin.job_audit from gp120;

revoke select on cpnadmin.last_offer_code from gp120;

revoke select on cpnadmin.user_sessions from gp120;

revoke select on cpnadmin.campaign_import_audit from gp120;

revoke select on cpnadmin.offers_export from gp120;

revoke select on cpnadmin.coupons_etl from gp120;

revoke select on cpnadmin.historic_offers from gp120;

revoke select on cpnadmin.offer_vendor from gp120;

revoke usage on schema cpnadmin from gp120;

revoke connect on database cpnprod from gp120;

drop user gp120;