| From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
|---|---|
| To: | Konstantin Pelepelin <konstantin(dot)pelepelin(at)gmail(dot)com> |
| Cc: | pgadmin-support(at)postgresql(dot)org |
| Subject: | Re: Restore option disabled for non-superuser |
| Date: | 2010-12-15 06:48:50 |
| Message-ID: | 4D0864D2.5050308@lelarge.info |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support |
Le 14/12/2010 22:35, Konstantin Pelepelin a écrit :
> PgAdmin 1.12.2 on WindowsXP
> postgresql 9.0 on linux
>
> When connecting as 'postgres', 'Restore' option is available, but when
> connecting as 'testuser' (simple user, nocreatedb), even for database
> owned by testuser, restore options are greyed out.
>
> I think they should not be disabled, in many scenarios db may be
> restored by non-superuser.
>
I didn't checked, don't have the time right now. But I read the source
code. It seems you only need to have the CREATE priviledge in the
database. So no need to be superuser or to have the createdb priviledge,
but you need to be a user who can create objects in that database. Which
seems fine to me.
--
Guillaume
http://www.postgresql.fr
http://dalibo.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Konstantin Pelepelin | 2010-12-15 10:35:43 | Re: Restore option disabled for non-superuser |
| Previous Message | Guillaume Lelarge | 2010-12-15 06:39:27 | Re: Max SQL file size? |