Grants a role to a user.
Available in the star$administration and requires the star$administration role.
Parameters:
| Name | Optional | Type | Description |
| user$ | Mandatory | Text | The user to grant the role to |
| role$ | Mandatory | Text | Role to be granted |
Examples:
SELECT grant_user('myuser','myrole'); -- grants role 'myrole' to user 'myuser'.
Tips:
- The star$users view lists existing users
- The star$roles view lists existing roles
Comments
Article is closed for comments.