On Wed, Mar 22, 2006 at 09:42:54 -0500, "Mr. Dan" <bitsandbytes88@xxxxxxxxxxx> 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.
