How to Drop User or Role in PostgreSQL Instance on Google Cloud Platform | GCP Tutorials 2022

How to Drop User or Role in PostgreSQL Instance on Google Cloud Platform | GCP SQL Tutorial 2022, in this video we are going to learn How to Drop User or Role in PostgreSQL Instance on Google Cloud Platform | GCP SQL Tutorial 2022, Google Cloud Platform Step by Step - GCP Tutorial 2022 - GCP Tutorial 2022 Step by Step - Google Cloud Platform Tutorial 2022. Script: ERROR: role "aamir" cannot be dropped because some objects depend on it DETAIL: owner of database test 1 object in database test SQL state: 2BP01 Error Invalid request: failed to delete user aamir: . role "aamir" cannot be dropped because some objects depend on it Details: owner of database test 1 object in database test. 0) Prepare the scenario Create user aamir and then create some objects create database Test create table public.mytable(id int, name varchar(100)); insert into public.mytable values(1,'aamir'); Select * from public.mytable; 1) -- Let's think about a user who has left the company and you need to drop the user. If you don't know the --password for the user, login by using postgres user and change the password of user. --How to change the password for role Alter role aamir LOGIN password 'Test123$'; 2) -- Tried to drop the role by using postgres user session drop role aamir -- you will get errot that objects are owened by user aamir GRANT postgres to aamir; --2 -- login by aamir user and run below command to assign all objects to postgres user REASSIGN OWNED BY aamir TO postgres; --3 login back to postgres and run below drop role aamir --4 Check if Objects are not dropped by dropping user. #googlecloudplatform Tutorial for beginners #googlecloudplatform Tutorial 2022 Step by step Google Cloud Platform Tutorial Real-time Google Cloud Platform Tutorial Scenario-based training on Google Cloud Platform Best GCP Tutorial on youtube #googlecloud #googlecloudplatform