ALTER DATABASE ... RENAME: permission denied for superuser
От | Alexander M. Pravking |
---|---|
Тема | ALTER DATABASE ... RENAME: permission denied for superuser |
Дата | |
Msg-id | 20050310104307.GA24145@dyatel.antar.bryansk.ru обсуждение исходный текст |
Ответы |
Re: ALTER DATABASE ... RENAME: permission denied for superuser
Re: ALTER DATABASE ... RENAME: permission denied for superuser |
Список | pgsql-bugs |
Docs say: Only the database owner or a superuser can rename a database; non-superuser owners must also have the CREATEDB privilege. Looks like a superuser must have CREATEDB too: fduch@~=# SELECT usesuper, usecreatedb from pg_user where usename = 'fduch'; usesuper | usecreatedb ----------+------------- t | f (1 row) fduch@~=# CREATE DATABASE test owner stat; CREATE DATABASE fduch@~=# ALTER DATABASE test RENAME TO work; ERROR: permission denied to rename database fduch@~=# ALTER DATABASE test OWNER TO fduch ; ALTER DATABASE fduch@~=# ALTER DATABASE test RENAME TO work; ERROR: permission denied to rename database At last: fduch@~=# ALTER USER fduch CREATEDB ; ALTER USER fduch@~=# ALTER DATABASE test RENAME TO work; ALTER DATABASE fduch@~=# ALTER DATABASE work OWNER TO stat; ALTER DATABASE fduch@~=# ALTER DATABASE work RENAME TO test; ALTER DATABASE PostgreSQL 8.0.1 on i386-portbld-freebsd5.3, compiled by GCC cc (GCC) 3.4.2 [FreeBSD] 20040728 -- Fduch M. Pravking
В списке pgsql-bugs по дате отправления: