revoke_user

Revokes a role from a user.

Available in the star$administration database and requires the star$administration role.

Parameters:

Name	Optional	Type	Description
user$	Mandatory	Text	User to revoke role from
role$	Mandatory	Text	Role to be revoked

Examples:

SELECT revoke_user('myuser','myrole'); -- revokes role 'myrole' from user 'myuser'.

Tips:

• The star$roles() view function lists roles granted to a specified user.
• The star$users view lists existing users
• The star$roles view lists existing roles