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
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