From the course: PostgreSQL Essential Training
Join today to access over 24,000 courses taught by industry experts.
User accounts and roles - PostgreSQL Tutorial
From the course: PostgreSQL Essential Training
User accounts and roles
- [Instructor] Securing data is one of the most important responsibilities of a database management system like Postgres. Controlling who has access to perform which tasks in a database is done through a mechanism called roles. There's a collection for them. Under the server level of the tree. Roles can be thought of as the user accounts that people use to log into the server with. In fact, in older versions of Postgres there were actually two different kinds of accounts users and groups, but since Postgres version 8.1 both of those entities have been combined into a single entity called a role. Now, there is no difference between an account intended for an individual or an umbrella account that's used by an entire team that have similar access requirements. Everything is just a role. Let's open up the collection and take a look. Here you can see that there's already a number of roles that have been created on the Postgres…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.