noob postgresql user question

Seth Gordon sethg-Dp9fwfP21SfQT0dZR+AlfA at public.gmane.org
Thu Nov 20 10:02:23 EST 2008


eric chadbourne wrote:
> i have access to a database via phppgadmin.  i've created a new user and 
> now want them to be able to use the db.
> 
> GRANT ALL PRIVILEGES
> ON DATABASE all_knowledge
> TO mr_cool;
> 
> it's not doing what i suspect.  my php scripts still can't access the db.

Even if you logged in as mr_cool to write your php scripts, they may not 
be running as mr_cool.  More likely, they're running with the identity 
of the Web server ("www-data" or "apache" or something else, depending 
on the distribution).






More information about the Discuss mailing list