This is an easy one.
issue the command 'createuser' (without quotes). It will prompt you for
the username to add. Enter user nobody, you can accecpt his Unix id. I
would say no to the ability to create a database and is superuser
questions.
Then you have to grant permissions to user nobody on the objects in the
database that you want to have read from the website.
Hope that helps.
Matt
-----Original Message-----
From: George Jempty
To: pgsql-admin@postgreSQL.org; pgsql-novice@postgreSQL.org
Sent: 2/26/00 6:12 PM
Subject: [ADMIN] Creating nobody user so website visitors can update
records
I got the following error message when testing my first postgresql web
page:
Warning: PostgresSQL query failed: WARN:counter: Permission denied. in
/home/ez4gl/public_html/index.phtml on line 15
However, at the psql prompt I am able to execute the very same query
that
resulted in the above, so I presume it has to do with the user "nobody"
accessing the web page.
I would appreciate instructions on how to set up the nobody user and
give
nobody the appropriate permissions so I can pass them along to my web
host,
as I don't have postmaster or superuser status to do it myself, and I
need
to spoon feed it to my web host so he won't keep trying to push mySQL on
me.
Thanks in advance
George Jempty
************