...
Also, you need to provide database privileges to the users you create in QAS. The following table shows minimum database privileges required for an Admin and Non-Admin users of QAS.
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 | |||
...