Example of Revoking One Role and Granting Another - Advanced SQL Engine - Teradata Database

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;