Granting Privileges to a Role

Go Up to Using Roles to Grant Privileges

Once a role has been defined, you can grant privileges to that role, just as you would to a user.

The syntax is as follows:

GRANT <privileges>
 ON [TABLE] {tablename | viewname}
 TO rolename;
<privileges> = ALL [PRIVILEGES] | <privilege_list>
<privilege_list> = {
SELECT
| DELETE
| INSERT
| UPDATE [(col [, col …])]
| REFERENCES [(col [, col …])]
} [, <privilege_list> …]

See the following section Granting a Role to Users for an example of creating a role, granting privileges to it, and then granting the role to users.