From the course: Database Foundations: Administration
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
View permissions on PostgreSQL
From the course: Database Foundations: Administration
View permissions on PostgreSQL
- [Instructor] Performing security audits is an important part of any database administrator's job. Once you begin incorporating user accounts into your database, you'll need a way of auditing the access privileges that have been granted to each one. This will be the first step in making sure that every user has an appropriate level of access to the database that's suited to their current areas of responsibility. To do this, we'll need to dive into the RDBMS system tables and views once again. Because the table names used by each platform are different, this requires a different set of commands for each one. But as you'll see, the overarching concepts are exactly the same. Let's start by taking a look at the PostgreSQL server. I'll expand the database's folder here and right-click on the two trees database to start up a new query. Now to save some typing, I'll paste in the script from the permission's PostgreSQL text…
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.