SQL Fundamentals

…

Lab5 objectives100 XP

02.Create Roles

List the name of every role. One column: rolname.
Which role do your statements run as?
How many roles are superusers?
Create a role analyst that can connect.
Create a role reporting that cannot connect.

Something unclear, wrong or missing?

Databaselab-db · PostgreSQL in your browser 0:00

SELECT * FROM pg_roles;

Ctrl↵runs the query · select text to run part of it

Objective 1 of 50/5 done

List every role's name
One column, rolname, one row per role.