Tutorial 21-How to manage a user and roles in PostgreSQL

In this session we are going to discuss about how to manage a user and roles in postgresql

What is meant by the user and role in postgresql?

i) user and role are synonyums to each others
ii) In postgresql it will behave wise versa
iii) user and role are almost same which will differ into some of
the characteristics
iv) user account is a connection to the DB
v) role is a necessary provider

The consideration of user and roles management



to Views the roles


select * from pg_roles;



Managing user& roles:

1. create user/create role

2. Alter User/Alter User

3. Drop User/Drop role

subscribe to our channel:
-----------------------------------------

For doubts and queries kindly contact us on
-----------------------------------------------------------------------

Follow us:

#Userandrolesmanagement
#uservsroles #postgresqlUserandrolesmanagement #managingpostgresqluserandroles #userandrolesmanagementinpostgresql

[nivithamani]

Hello sir, In my case new user has superuser role so that I can see the idle sessions of other user sessions in the pg_stat_activity view but I don't want give super user role to new user. Is there alternative way to grant priviledges/role to see the idle sessions of other non superuser.