I'm wondering about my CREATE ROLE statements for PostgreSQL. I guess I don't know if there's an official answer but I feel like I'm entering a lot of redundant privileges to a role for example: CREATE ROLE tom NOINHERIT LOGIN SUPERUSER CREATEDB CREATEROLE REPLICATION; CREATE ROLE My question is do I need to specify CREATEDB & CREATEROLE if I'm already granting the SUPERUSER privilege? Seems kind of redundant to me, no? Is there any logical reason someone would be a SUPERUSER and not have CREATEDB or CREATEROLE? Also when I generate a new role, is there any difference between using: ALTER ROLE tom ENCRYPTED PASSWORD 'md5081bea17b5503506d29531af33cc6f4e'; \password tom Is there a downside to using the \password psql command? Is it also encrypted like the statement above? How do you create roles and do you do it manually or have some kind of template? -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
