Hi. I have postgresql on a system SPARC (solaris 2.7) and on a system PC (linux).
I have a problem. I'm using libpq from a cgi with C. The user "nobody" is for service
httpd on my Apache web server.
I am the superuser of my postgresql, and so I did:
createuser nobody
yes, nobody can create new user
no, nobody can't create new DB
*******************
>From my Solaris system
*******************
nobody:
$ /usr/local/pgsql/bin/psql jonica1
Welcome to the POSTGRESQL interactive sql monitor:
Please read the file COPYRIGHT for copyright terms of POSTGRESQL
type \? for help on slash commands
type \q to quit
type \g or terminate with semicolon to execute query
You are currently connected to the database: jonica1
jonica1=> \dt
Database = jonica1
+------------------+----------------------------------+----------+
| Owner | Relation | Type |
+------------------+----------------------------------+----------+
| enrique | datos | table |
| enrique | inmobi | table |
+------------------+----------------------------------+----------+
jonica1=> select * from datos;
ERROR: datos: Permission denied. <<<<<<<<< WHY ???????
**************
>From my linux system
**************
nobody: psql jonica1
job-working-directory: could not get current directory: getwd: cannot access parent
directories
Welcome to the POSTGRESQL interactive sql monitor:
Please read the file COPYRIGHT for copyright terms of POSTGRESQL
type \? for help on slash commands
type \q to quit
type \g or terminate with semicolon to execute query
You are currently connected to the database: jonica1
jonica1=> \dt
Database = jonica1
+------------------+----------------------------------+----------+
| Owner | Relation | Type |
+------------------+----------------------------------+----------+
| enrique | datos | table |
| enrique | inmobi | table |
+------------------+----------------------------------+----------+
jonica1=> select refinmo from inmobi;
refinmo
-------
10
9
15
1
2
12
11
14
13
3
4
5
6
7
8
(15 rows)
Why?. I can't understand?.
Thanks in advanced.
--
==============================================
Enrique Rodr�guez L�zaro
