Re: Understanding Roles & Grant Options - Mailing list pgsql-general

From Tom Lane
Subject Re: Understanding Roles & Grant Options
Date
Msg-id 27099.1293728422@sss.pgh.pa.us
Whole thread Raw
In response to Understanding Roles & Grant Options  (Carlos Mennens <carlos.mennens@gmail.com>)
List pgsql-general
Carlos Mennens <carlos.mennens@gmail.com> writes:
> I've been reading the documentation and I'm trying to understand what
> 'GRANT' options make up a 'superuser' in PostgreSQL.

Superuser-ness is not a grantable privilege; it's an attribute of a
role.  See CREATE/ALTER ROLE.

> Obviously 'Carlos' is a superuser but what does that exactly entail
> beyond CREATEDB & CREATEROLE?

A superuser succeeds at any privilege test whatsoever.

            regards, tom lane

pgsql-general by date:

Previous
From: Carlos Mennens
Date:
Subject: Understanding Roles & Grant Options
Next
From: Vincent Veyron
Date:
Subject: Re: Restore problem