Verify your knowledge

• What is a role?

  A role can be a single user or a group of users that have access to the cluster and its databases. A role is the basic unit to grant access and define permissions. See the Understanding roles section for more details.

• What does the INHERITS clause do?

  The INHERITS clause makes a role inherit, that is get, instantly and dynamically all the permissions granted to the role from which it inherits. Without the INHERITS clause, the role still has the permissions of the role it belongs to, but an explicit SET ROLE is required in order to use such permissions. See the Roles that inherit from other roles section for more details.

• What is an Access Control List (ACL)?

  An ACL is the specification of a set of permissions attached to a database object, and is the way PostgreSQL implements and store the permissions. See the ACLs section for more details.

• What are the statements to add...