Permissions to a schema

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