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]
Follow us:
www.facebook.com/MyNotesOracleDba
#Userandrolesmanagement
#uservsroles #postgresqlUserandrolesmanagement #managingpostgresqluserandroles #userandrolesmanagementinpostgresql
Watch video Tutorial 21-How to manage a user and roles in PostgreSQL online without registration, duration hours minute second in high quality. This video was added by user mynotesoracledba 02 July 2020, don't forget to share it with your friends and acquaintances, it has been viewed on our site 7,25 once and liked it 4 people.