CODE EXAMPLE FOR SQL

pl sql revoke role from user

REVOKE ROLENAME FROM USERNAME;