| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Carlos Mennens <carlos(dot)mennens(at)gmail(dot)com> |
| Cc: | "PostgreSQL (General)" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Defining Role Privileges |
| Date: | 2012-02-08 16:56:16 |
| Message-ID: | 27432.1328720176@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Carlos Mennens <carlos(dot)mennens(at)gmail(dot)com> writes:
> My question is do I need to specify CREATEDB & CREATEROLE if I'm
> already granting the SUPERUSER privilege?
No, not really. The point of those options is to grant privileges to
roles that aren't superuser.
> Also when I generate a new role, is there any difference between using:
> ALTER ROLE tom ENCRYPTED PASSWORD 'md5081bea17b5503506d29531af33cc6f4e';
> \password tom
Don't think so, except that in the former case you have to work out the
encrypted password by hand. The latter is safer since the cleartext
password will not escape the psql executable.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andreas Kretschmer | 2012-02-08 17:13:36 | Re: easy function or trigger to UPPER() all alpha data |
| Previous Message | Andreas Kretschmer | 2012-02-08 16:51:09 | Re: easy function or trigger to UPPER() all alpha data |