pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedBug in user management?
3+ messages / 3 participants
[nested] [flat]
* Bug in user management?
@ 2001-04-12 11:03 Hans-Jürgen Schönig <hs@cybertec.at>
2001-04-13 23:10 ` Re: Bug in user management? Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 3+ messages in thread
From: Hans-Jürgen Schönig @ 2001-04-12 11:03 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Bug in user management?
2001-04-12 11:03 Bug in user management? Hans-Jürgen Schönig <hs@cybertec.at>
@ 2001-04-13 23:10 ` Tom Lane <tgl@sss.pgh.pa.us>
2001-04-14 21:09 ` Re: Bug in user management? Cedar Cox <cedarc@visionforisrael.com>
0 siblings, 1 reply; 3+ messages in thread
From: Tom Lane @ 2001-04-13 23:10 UTC (permalink / raw)
To: Hans-Jürgen Schönig <hs@cybertec.at>; +Cc: pgsql-sql
=?iso-8859-1?Q?Hans=2DJ=FCrgen=20Sch=F6nig?= <hs@cybertec.at> writes:
> I have created a user called epi who is not allowed to create database
> but allowed to create users.
The "CREATEUSER" option is rather badly mislabeled: the privilege it
actually grants is superuser status. You are laboring under a severe
misapprehension if you think that epi has ANY restrictions on what he
can do ...
regards, tom lane
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Bug in user management?
2001-04-12 11:03 Bug in user management? Hans-Jürgen Schönig <hs@cybertec.at>
2001-04-13 23:10 ` Re: Bug in user management? Tom Lane <tgl@sss.pgh.pa.us>
@ 2001-04-14 21:09 ` Cedar Cox <cedarc@visionforisrael.com>
0 siblings, 0 replies; 3+ messages in thread
From: Cedar Cox @ 2001-04-14 21:09 UTC (permalink / raw)
To: pgsql-sql
While we're on this subject, where is the documentation on
pg_shadow? Specifically, what it 'usetrace' for?
-Cedar
On Fri, 13 Apr 2001, Tom Lane wrote:
> =?iso-8859-1?Q?Hans=2DJ=FCrgen=20Sch=F6nig?= <hs@cybertec.at> writes:
> > I have created a user called epi who is not allowed to create database
> > but allowed to create users.
>
> The "CREATEUSER" option is rather badly mislabeled: the privilege it
> actually grants is superuser status. You are laboring under a severe
> misapprehension if you think that epi has ANY restrictions on what he
> can do ...
>
> regards, tom lane
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2001-04-14 21:09 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-04-12 11:03 Bug in user management? Hans-Jürgen Schönig <hs@cybertec.at>
2001-04-13 23:10 ` Tom Lane <tgl@sss.pgh.pa.us>
2001-04-14 21:09 ` Cedar Cox <cedarc@visionforisrael.com>
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