Managing Users and Roles

All of your user and role management can be completed using the Administration interface.

Creating Roles

1. Log into Kinetica with an administration account.

2. From the Security menu, click Users.

   

3. Click New.

   

4. Type a name for the role into the Role field.

5. Select a system-level permission as necessary from the System Level Permission drop-down menu.

6. From the Table Level Permissions section, assign table-level permissions as necessary by selecting a table in the left list and a permission in the right list and then clicking Add. The permission-to-table association will be displayed below the selection boxes, and the Effective Permissions table will be updated accordingly. Note that the Table Admin permission allows the user to delete, insert, read, and update the table. If you need to remove an added tabel-level permission, select a given permission and then click - Remove.

   

7. In the Members section, add members (users and/or roles) to a role by selecting an item in the Available list and clicking Add >>. The Selected list will get updated with that user or role accordingly. If you need to remove a selected member, select a given member and then click << Remove.

   

8. Click Create.

Creating Users

1. Log into Kinetica with an administration account.

2. From the Security menu, click Users.

   

3. Click New.

   

4. Select the type of Authentication. It's important to note that External users are authenticated using an LDAP server, so the username has to be duplicated in Kinetica but with an @ prepended, e.g., @user1. More information on the authentication types can be found on Security Concepts.

5. Type the username into the User field and the password into the Password field (passwords are required for Internal users only). Type the password again in the Confirm Password field.

6. Add or remove selected roles as necessary in the Member of Roles section:

   • Add: Click a role in the Available Roles list and then click Add >>.
   • Remove: Click a role in the Selected Roles list and then click << Remove.

7. Select a system-level permission as necessary from the System Level Permission drop-down menu.

8. From the Table Level Permissions section, assign table-level permissions as necessary by selecting a table in the left list and a permission in the right list and then clicking Add. The permission-to-table association will be displayed below the selection boxes, and the Effective Permissions table will be updated accordingly. Note that the Table Admin permission allows the user to delete, insert, read, and update the table.

   

9. Click Create.

Editing User Permissions

1. Log into Kinetica with an administration account.

2. From the Security menu, click Users.

   

3. From the table of users, select a user you want to edit. The Edit button is now enabled.

4. Click Edit.

5. Add or remove selected roles as necessary in the Member of Roles section:

   • Add: Click a role in the Available Roles list and then click Add >>.
   • Remove: Click a role in the Selected Roles list and then click << Remove.

6. Update the user's system level permission by selecting a new option from the System Level Permission drop-down menu.

7. From the Table Level Permissions section, assign table-level permissions as necessary by selecting a table in the left list and a permission in the right list and then clicking Add.

8. Also from the Table Level Permissions section, remove table-level permissions by selecting a given permission and then clicking - Remove.

9. Click Save.