Re: Permissions to a schema

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
> http://webservices.uiuc.edu
>