...
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.
...
- From the Expand Menu, click User Management.
- Click the Roles tab.
- In the left pane, click the Add Role button (
). - Enter the name of a role in the Role box.
- Enter Description.
- Under Assigned Privileges, select the checkboxes of the privileges that you want to map with the role .
- 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.
...
- From the Expand Menu, click User Management.
- Click the Roles tab.
- In the left pane, select the role you want to edit.
- Click the Edit Role button (
). - Edit the name of the role in the Role box, if required.
- Edit the Description box, if required.
- (Optional) You can assign with new privileges or unassign with existing privileges.
- Click OK.
The selected role is saved with the edited values.
Removing a Role
| Info |
|---|
Note: You cannot delete a role if it is assigned to a user. |
...