I believe that this is dependent on what version of postgres you are using. What you want to do is create a role. You do this by issuing the CREATE ROLE command...
CREATE ROLE select_role;
GRANT SELECT on MyTable to select_role;
GRANT select_role TO MyUser;
Carol
On Feb 3, 2009, at 11:33 AM, Campbell, Lance wrote:
How do I do the following:
1) Create a user group.
2) Assign access to select, delete, insert, and update to any table found in the following X number of schemas.
3) Assign the newly created user group permissions to a new user.
Thanks,
Lance Campbell
Project Manager/Software Architect
Web Services at Public Affairs
University of Illinois
217.333.0382