Re: Restore option disabled for non-superuser

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.


-- 
Guillaumehttp://www.postgresql.frhttp://dalibo.com