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.