Re: [HACKERS] Permissions not working? - Mailing list pgsql-hackers

From darcy@druid.net (D'Arcy J.M. Cain)
Subject Re: [HACKERS] Permissions not working?
Date
Msg-id m0zShdg-0000emC@druid.net
Whole thread Raw
In response to Re: [HACKERS] Permissions not working?  (jwieck@debis.com (Jan Wieck))
List pgsql-hackers
Thus spake Jan Wieck
>     I  assume user carol does not have usesuper set in pg_shadow.

Correct.

>     Here I assume user darcy has usesuper set in pg_shadow. Check
>     and correct me if I'm wrong. The superuser flag is set if you
>     allow darcy to create users on createuser time.

Correct again.  I half suspected something like this.  Perhaps the
prompt in createuser should be changed to reflect that the user is
being granted full superuser privileges rather than just being able
to create more users.

--
D'Arcy J.M. Cain <darcy@{druid|vex}.net>   |  Democracy is three wolves
http://www.druid.net/darcy/                |  and a sheep voting on
+1 416 424 2871     (DoD#0082)    (eNTP)   |  what's for dinner.

pgsql-hackers by date:

Previous
From: jwieck@debis.com (Jan Wieck)
Date:
Subject: Re: [HACKERS] Permissions not working?
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Open 6.4 items