The following statements create roles called services and sales:
CREATE ROLE services; CREATE ROLE sales;
To make sales a nested role of services, use the following GRANT statement:
GRANT sales TO services;
To grant the sales role to user marks, and give marks the privilege to add other members to sales, use the following GRANT statement:
GRANT sales TO marks WITH ADMIN OPTION;