Re: Permissions to a schema

[Carol Walter <walterc@xxxxxxxxxxx>]

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