| From: | Petr Plasil <plasa(at)falcor(dot)karlin(dot)mff(dot)cuni(dot)cz> |
|---|---|
| To: | pgsql-admin(at)postgreSQL(dot)org |
| Subject: | Can't create superuser |
| Date: | 2000-01-26 17:25:09 |
| Message-ID: | Pine.LNX.3.94.1000126182428.21223A-100000@falcor.karlin.mff.cuni.cz |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hello,
I have a following problem:
I successfully did
CREATE USER user1
WITH PASSWIRD xxx
CREATEDB
CREATEUSER,
but when I connect as user1, I can't create other users - I am getting a
message
ERROR: defineUser: user "user1" does not have SELECT and INSERT privilege
for "pg_shadow".
I've checked pg_user - and he has both USESUPER and USECATUPD set.
The server uses PASSWORD autentification, but at the time of creation of
user1 this was set as TRUSTED - could this be the problem?.
Petr Plasil
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sarah Officer | 2000-01-26 22:01:53 | ugly name clash |
| Previous Message | ytnufu | 2000-01-26 17:11:54 | rachel.jpg 4678 |