Document toolboxDocument toolbox

Role Management

Owned by ravi.chandran (Unlicensed)
Jul 14, 2021

Qualitia implements role-based security for users. Roles are based on functionality of users like Testers, Automation Test Engineers, and so on. Appropriate privileges are assigned to the roles.

Qualitia Automation Studio (QAS) contains the following five pre-defined roles assigned with specific Qualitia privileges:

  • Admin
  • Custom Action
  • Project Manager
  • Test Lead
  • Tester

You can create a custom role using the Qualitia's  pre-defined privileges.

The minimum database privileges required for a Qualitia user with an Admin or a Non-Admin role are shown in the following table.


MySQL Privileges

SQL Server Privileges

Qualitia Admin User

Qualitia Non-Admin User

Qualitia Admin User

Qualitia Non-Admin User

CREATE

INSERT

CREATE TABLE

SELECT 

REFERENCES

SELECT

ALTER 

UPDATE 

DROP 

CREATE ROUTINE 

REFERENCES 

INSERT 

TRIGGER 

CREATE VIEW 

CREATE PROCEDURE 

DELETE

ALTER 

UPDATE 

CREATE DATABASE 


INDEX  

DELETE 

SELECT 


INSERT

CREATE TEMPORARY TABLES 

UPDATE 


SELECT

EXECUTE 

INSERT 


CREATE ROUTINE 


DELETE


CREATE VIEW 




UPDATE 




DELETE 




CREATE TEMPORARY TABLES 




EXECUTE




Adding a Role

Different users perform different roles while working on projects. Some of them could be testers, test-leads, project managers, and so on. The role assigned to a user determines the privileges of the user.

In Qualitia, by using the Roles screen, you can create roles with appropriate privileges.

To create a Role:

  1. From the Expand Menu, click User Management.
  2. Click the Roles tab.
  3. In the left pane, click the Add Role button ().
  4. Enter the name of a role in the Role box.
  5. Enter Description.
  6. Under Assigned Privileges, select the checkboxes of the privileges that you want to map with the role .
  7. Click Save.
    The new role is created and listed in the Roles table of Roles screen.

Editing a Role

You may need to edit the details related to the roles. You can edit the name of a role, its description, or the assigned privileges as per project requirements.

In Qualitia, using Roles screen, you can edit the name of a role, its description, or assigned privileges.

 To edit a Role:

  1. From the Expand Menu, click User Management.
  2. Click the Roles tab.
  3. In the left pane, select the role you want to edit.
  4. Click the Edit Role button ().
  5. Edit the name of the role in the Role box, if required.
  6. Edit the Description box, if required.
  7. (Optional) You can assign with new privileges or unassign with existing privileges.
  8. Click OK.
    The selected role is saved with the edited values. 

Removing a Role

Note: You cannot delete a role if it is assigned to a user.

To remove a role:

  1. From the Expand Menu, click User Management.
  2. Click the Roles tab.
  3. In the left pane, click the Remove Role button ().