ROLES in database are created by using the statement CREATE ROLE. DROP ROLE statement is used to drop the created roles in database. The roles are extended with privileges by using GRANT statement. The privileges assigned to a USER can be revoked by using the REVOKE statement. A user can obtain all the privileges allied with a role by using the statement SET ROLE. The CURRENT_ROLE FUNCTION will RETURN the present role in a statement. Only roles which are granted to the user can be set along with the user while setting other role to user is not permitted.

Roles in database are created by using the statement CREATE ROLE. DROP ROLE statement is used to drop the created roles in database. The roles are extended with privileges by using GRANT statement. The privileges assigned to a user can be revoked by using the REVOKE statement. A user can obtain all the privileges allied with a role by using the statement SET ROLE. The CURRENT_ROLE function will return the present role in a statement. Only roles which are granted to the user can be set along with the user while setting other role to user is not permitted.