I'd like to have different users mainly to have a different search schema path. Things may evolve so this is not going to be the only reason to have more than one user. But I'm faced with the problem of granting the same access of the owner of the db to the other users. But I read: http://www.postgresql.org/docs/8.3/static/sql-grant.html The SQL standard does not support setting the privileges on more than one object per command. This is going to make maintenance and development a PITA every time I add a new table, sequence, schema... Defining a role/group with all grant access and then assigning that group to all users is going to make this a bit less painful, but still every time I'm going to add something to the DB I'll have to remember to modify the group privileges. Even when things will evolve, all users should be able to do everything to most object with a few exception so it is easier to revoke than to grant. Any advice even with completely different approach? thanks -- Ivan Sergio Borgonovo http://www.webthatworks.it -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
