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

1.authentication
2.authorisation

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:
—————————————–
https://rebrand.ly/8z3l1y1

For doubts and queries kindly contact us on
———————————————————————–
[email protected]

www.facebook.com/MyNotesOracleDba

#Userandrolesmanagement
#uservsroles #postgresqlUserandrolesmanagement #managingpostgresqluserandroles #userandrolesmanagementinpostgresql