On Wed, Mar 22, 2006 at 09:42:54 -0500,
"Mr. Dan" <bitsandbytes88@hotmail.com> wrote:
> Hi,
>
> Pgadmin is amazing. You can log on with a user account that's been
> authenticated through Linux PAM and then run a command like pg_dump or
> createdb that you wouldn't have access to run on the linux command line as
> long as postgres approves that access. Is there a way to bring that power
> to the command line? If I log into a server as a certain user who doesn't
> have the access that the postgres user has, can I use or access postres
> someway to check that a superuser has given that access in postrres and if
> it has wrap around the postgres user account (like what happens with
> pgadmin) and execute the command like createdb?
>
> Is there a web based version of pgadmin? Is the source available for
> pgadmin?
It is possible to do things like this. Probably some mix of ident
authentication and sudo would work.