Skip site navigation (1) Skip section navigation (2)

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: 2007-08-16 15:46:20
Message-ID: 46C4714C.4090701@postgresql.org (view raw or flat)
Thread:
Lists: pgadmin-hackers
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.

In response to

Responses

pgadmin-hackers by date

Next:From: Erwin BrandstetterDate: 2007-08-16 16:42:09
Subject: Re: SQL for CREATE ROLE xxx SUPERUSER
Previous:From: Erwin BrandstetterDate: 2007-08-16 15:36:15
Subject: Re: SQL for CREATE ROLE xxx SUPERUSER

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group