Hi, I felt that this place is more appropriate to ask my question. I
already posted at psql-novice, but got no response. Here we go:
Right now, I have the following user management concept:
-) when creating a database, an equally named role is created; every
user of this db is in this role, t
Sven Sporer <[EMAIL PROTECTED]> writes:
> 2) How do you restrict the users of a specific database to touch only
> the objects in their database?
They *are* so restricted. Your problem is that roles are
installation-wide, not local to a particular database, and
so you cannot enforce the restrict
I had this same problem on Win2003, but I resolved it in short way,
without analysis of problem - I make dumps as owner of database.
I suppose, there is a problem with full access to system tables with "no
owner" privilleges to dumped database.
I think it could be problem on all supported platfor
Hi folks,
i have a workgroup (not a classic server) with Windows-XP-machines:
the database server machine contains the line
host all all 0.0.0.0 0.0.0.0 md5
in the file pg_hba.conf
and
listen_addresses = '*'
in the file postgresql.conf.
The clients' host file contain the line
nnn
