REVOKE ROLE
Syntax
REVOKE ROLE role_name USER username [DATABASE database_name] [TABLE table_name]
Privileges
USERADMINDescription
Use this command to revoke a role from the USER username. You can further restrict this command by specifying a database and/or a table name.
Return
OK string or error value (see SCSP protocol).
Example
> REVOKE ROLE role1 USER user1
OK