You can do this in phpPgAdmin... it's a hack because it just pulls in all
the objects/relations and runs a single grant statement on them, but it
works. It puts together a query like the following:
GRANT ALL ON table1, table2, table3, view1, view2, sequence1, sequence2 TO
user
Which I suppose you can do manually if you don't have phpPgAdmin installed.
It ain't the prettiest, but it works!
-Dan
: El Mié 31 Ene 2001 15:53, Michael Fork escribió:
: > This is the closest thing to what you want:
: >
: > GRANT ALL ON table TO user;
: >
: > (see http://www.postgresql.org/users-lounge/docs/7.0/user/sql-grant.htm)
:
: Yes, I'm aware of that. That's why I'm asking for an opinion of the
: developers on this issue.
: I think it would be a nice feature, so that the postgres user creates the
: database and gives all kind of permissions on that database to another
user,
: which doesn't have to be able to create databases.