Bug in user management?
От | Hans-Jürgen Schönig |
---|---|
Тема | Bug in user management? |
Дата | |
Msg-id | 3AD58B75.D5911B57@cybertec.at обсуждение исходный текст |
Ответы |
Re: Bug in user management?
|
Список | pgsql-sql |
I need some information about PostgreSQL user management. <br />I have created a user called epi who is not allowed to createdatabase but allowed to create users. <br />I have connected as user epi and have then created user kertal with thefollowing command: <p>shop=# CREATE USER kertal WITH PASSWORD 'anypasswd' CREATEDB CREATEUSER IN GROUP cybertec; <p>Accordingto the system table kertal is allowed to create databases - I have also tried this as user kertal and it works.<br />In my opinion a user that has not the right to create database MUST NOT create user that are allowed to do it.<p>Have I done something wrong or is it a bug? <p> Hans <br /> <p>persons=# SELECT * FROM pg_user ; <br /> usename | usesysid | usecreatedb | usetrace | usesuper | usecatupd | passwd | <br />valuntil <br />----------+----------+-------------+----------+----------+-----------+----------+----------<br /> postgres | 26 |t | t | t | t | ******** | <br /> hans | 27 | f | f | f | f | ******** | <br /> epi | 28 | f | f | t | t | ******** |<br /> kertal | 29 | t | f | t | t | ******** | <br />(4 rows) <br /> <pre>-- ------------------------------------------------------------------- Cybertec Geschwinde &. Schönig OEG; Schönbrunnerstraße 133/18 A-1050 Wien; <a href="http://postgres.cybertec.at">http://postgres.cybertec.at</a>; Fax.: +43/1/961 71 58 Tel.: +43/664/233 90 75</pre>
В списке pgsql-sql по дате отправления: