...
You can create a custom role using the nine pre-defined privileges.
Also, Admin and other non-admin user have been given other Qualitia database privileges as shown in the following table.
...
MySQL
...
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.
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.
...