Use the GRANT statement to grant privileges to the roles necessary to serve the basic user types. A GRANT statement takes the following basic form:
GRANT privilege ON database_object_name TO role_name;
Not all privileges need to be granted using roles. Granting specialized privileges directly to a user may be more efficient than creating a role with a membership of one.
Any user can grant privileges on any of its own database objects to any other user or role, excluding the CREATE and DROP privileges, which are not ownership privileges.
For example:
GRANT EXECUTE, SELECT, INSERT, UPDATE, DELETE, DUMP, RESTORE, CHECKPOINT, CREATE TABLE, DROP TABLE ON "Tables_Database" TO "Role_BatchUser_2";