...
Database credentials are required to configure the Qualitia client with your database server. As per the role of the Qualitia user, you need to provide database privileges. The minimum database privileges required for a database credential in use for a Qualitia role is given 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.
...