| From: | Carlos Mennens <carlos(dot)mennens(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Understanding Roles & Grant Options |
| Date: | 2010-12-30 16:50:59 |
| Message-ID: | AANLkTinTaMPO7857Oz5O2b9q+Oaxcx4W_4_oC3jKB5hB@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I've been reading the documentation and I'm trying to understand what
'GRANT' options make up a 'superuser' in PostgreSQL.
I've got my account which is 'carlos' and then I have an account
called 'jason'. Can someone please explain the difference between the
two roles:
postgres=# \dg
List of roles
Role name | Attributes | Member of
-----------+--------------+-----------
carlos | Superuser | {it}
it | Cannot login | {}
jason | Create role | {it}
: Create DB
postgres | Superuser | {}
: Create role
: Create DB
Obviously 'Carlos' is a superuser but what does that exactly entail
beyond CREATEDB & CREATEROLE?
http://www.postgresql.org/docs/8.1/static/app-createuser.html
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2010-12-30 17:00:22 | Re: Understanding Roles & Grant Options |
| Previous Message | pasman pasmański | 2010-12-30 16:15:01 | Cursors WITH HOLD |