From the course: Database Foundations: Administration
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
PostgreSQL role permissions
From the course: Database Foundations: Administration
PostgreSQL role permissions
- [Instructor] We've talked a lot about some of the concepts around managing database security through principal user accounts. Let's put that into practice in the PostgreSQL database. The first thing that we need to know is that PostgreSQL doesn't make a distinction between individual users and user groups. Every principal account is considered a role, and every role can have several members. If you take a look at the connection sidebar in the PostgreSQL server, below the Databases folders, you'll find a folder for the roles. Inside are a number of different roles that come pre-configured on the server. One of them at the very bottom is the postgres role. This is the administrator account that we've been using since the very beginning to log into the server and execute commands. If you go back up and right click on the two_trees database and choose New Query, the query tab uses the permissions of the postgres role. You…
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.