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
Смотрите видео Tutorial 21-How to manage a user and roles in PostgreSQL онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь mynotesoracledba 02 Июль 2020, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 7,255 раз и оно понравилось 41 людям.