Role Management

Role management feature in InformixHQ provides a structured way to control user access and privileges by grouping permissions into roles. This simplifies security administration and helps ensure users have the appropriate level of access based on their responsibilities. In InformixHQ, roles are database-specific, meaning they are defined and used within the scope of a particular database and do not extend across multiple databases.

System administrative users of InformixHQ can access the Role Management feature from the DB Server Administration >Privileges > Role Management

Key Features of Role Management

1. Create role: Select a database and then create a new role by providing a unique role name that identifies the role within the database.
2. Create a default role: To create a default role, select a role name and specify the username to which the role should be automatically assigned during creation.
3. Assign Privileges to the role: Select the role you want to configure, then choose one or more tables and assign the appropriate privileges (e.g., SELECT, INSERT, UPDATE) to the role.
4. Assign Role to User: To assign a role to a user, select the username and then choose the role you wish to assign.
5. Revoke role from user:
   1. Go to the User List under the Database tab.
   2. Click the Edit button next to the relevant user.
   3. In the user’s Roles section, locate the role to be removed.
   4. Click Delete next to that role to revoke it from the user.
6. Delete Role: To permanently remove a role from the system, click the Delete button next to the role in the roles list in the Role Management tab.