Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: SQL for CREATE ROLE xxx SUPERUSER
- From: Dave Page <dpage(at)postgresql(dot)org>
- To: Erwin Brandstetter <brandstetter(at)falter(dot)at>
- Cc: pgadmin-hackers(at)postgresql(dot)org
- Subject: Re: SQL for CREATE ROLE xxx SUPERUSER
- Date: Thu, 16 Aug 2007 16:46:20 +0100
- Message-id: <46C4714C(dot)4090701(at)postgresql(dot)org>
Erwin Brandstetter wrote:
Hi Dave! But is the line needed at all? Clearly it works the same way with just "CREATE ROLE tester SUPERUSER".
It's not the same thing - pg_authid.rolsuper is the superuser flag, pg_authid.rolcatupdate is the catalog update flag. It cannot be set with CREATE or UPDATE ROLE, and is required for even a superuser to directly update the catalogs (postgres has it by default though).
Regards, Dave.
- Follow-Ups:
- Re: SQL for CREATE ROLE xxx SUPERUSER
- From: Erwin Brandstetter
- Re: SQL for CREATE ROLE xxx SUPERUSER
- References:
- SQL for CREATE ROLE xxx SUPERUSER
- From: Erwin Brandstetter
- Re: SQL for CREATE ROLE xxx SUPERUSER
- From: Dave Page
- Re: SQL for CREATE ROLE xxx SUPERUSER
- From: Erwin Brandstetter
- SQL for CREATE ROLE xxx SUPERUSER
- Prev by Date: Re: SQL for CREATE ROLE xxx SUPERUSER
- Next by Date: Re: SQL for CREATE ROLE xxx SUPERUSER
- Previous by thread: Re: SQL for CREATE ROLE xxx SUPERUSER
- Next by thread: Re: SQL for CREATE ROLE xxx SUPERUSER
- Indexes: