pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Hans-Jürgen Schönig <hs@cybertec.at>
To: pgsql-sql@postgresql.org
Subject: Bug in user management?
Date: Thu, 12 Apr 2001 13:03:17 +0200
Message-ID: <3AD58B75.D5911B57@cybertec.at> (raw)

I need some information about PostgreSQL user management.
I have created a user called epi who is not allowed to create database
but allowed to create users.
I have connected as user epi and have then created user kertal with the
following command:

shop=# CREATE USER kertal WITH PASSWORD 'anypasswd' CREATEDB CREATEUSER
IN GROUP cybertec;

According to the system table kertal is allowed to create databases - I
have also tried this as user kertal and it works.
In my opinion a user that has not the right to create database MUST NOT
create user that are allowed to do it.

Have I done something wrong or is it a bug?

    Hans


persons=# SELECT * FROM pg_user ;
 usename  | usesysid | usecreatedb | usetrace | usesuper | usecatupd |
passwd  |
valuntil
----------+----------+-------------+----------+----------+-----------+----------+----------

 postgres |       26 | t           | t        | t        | t         |
******** |
 hans     |       27 | f           | f        | f        | f         |
******** |
 epi      |       28 | f           | f        | t        | t         |
******** |
 kertal   |       29 | t           | f        | t        | t         |
******** |
(4 rows)


--
-------------------------------------------------------------------
Cybertec Geschwinde &. Schönig OEG; Schönbrunnerstraße 133/18
A-1050 Wien; http://postgres.cybertec.at; Fax.: +43/1/961 71 58
Tel.: +43/664/233 90 75

view thread (3+ messages)  latest in thread

Message-ID: <3AD58B75.D5911B57@cybertec.at>
Permalink:  ../3AD58B75.D5911B57@cybertec.at/
Also on:    postgresql.org/message-id/3AD58B75.D5911B57@cybertec.at

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: hs@cybertec.at
  Subject: Re: Bug in user management?
  In-Reply-To: <3AD58B75.D5911B57@cybertec.at>
  References: <3AD58B75.D5911B57@cybertec.at>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox