From: | Hans-Jürgen Schönig <hs(at)cybertec(dot)at> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Bug in user management? |
Date: | 2001-04-12 11:03:17 |
Message-ID: | 3AD58B75.D5911B57@cybertec.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Lonnie Cumberland | 2001-04-12 13:23:54 | Re: Calling plSQL functions |
Previous Message | Luis C. Ferreira | 2001-04-12 06:05:36 | Re: enumerating rows |