Example of Revoking One Role and Granting Another - Database Engine 20 - Teradata Vantage

If user marks gets a promotion from sales to management, the DBA can use the following statements to revoke the sales role and grant the management role:

REVOKE sales
FROM marks;
     
GRANT management
TO marks;