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

[@faizahmed8015]

When I'm altering password it says role amir dose not exist? Although do think what you did.