|Anonymous | Login | Signup for a new account||2020-01-28 00:41 UTC|
|Main | My View | View Issues | Change Log | My Account|
|View Issue Details|
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0008775||TestLink||Users and Rights||public||2019-09-25 12:48||2019-09-25 16:16|
|Product Version||1.9.19.01 (1.9.19 fixes)|
|Fixed in Version|
|Summary||0008775: Bulk set of users with admin role to leaders|
|Description||Dear TestLink support,|
Since on the current Testlink version regular users cannot have admin privileges on specific projects we would like to set all our users with this privileges (inherited from old TestLink versions) to role leader.
As such we have developed the 2 queries below as to make it an easier and faster task:
update user_testproject_roles set role_id = 9 where role_id = 8 and user_id <> 1;
update user_testplan_roles set role_id = 9 where role_id = 8 and user_id <> 1;
Note: User_id 1 is admin and role_id 9 is leader while role_id 8 is admin.
Can you please validate this method and respective query.
Moreover is there a way for regular users to add and configure roles of users inside a given project/plan? Or this has to be done always by the admin user?
|Tags||No tags attached.|
|Database (MySQL,Postgres,etc)||MySQL 5.7.24|
|QA Team - Task Workflow Status||TBD|
>> Moreover is there a way for regular users to add and configure roles of users inside a given >> project/plan? Or this has to be done always by the admin user?
these are questions that may be can be solved reading the manual or doing some experiments => mantis is not the place => use forum.testlink.org to ask for other user's help.
Time available is limited to provide this kind of support.
Time is used to fix issues or implement new features.
This can be considered training => if you need one you can buy it.
Before adding here the question here I obviously did my share of investigation. Found nothing. My bad most likely.
Didn't event found and updated Testlink Manual.
In any case the most relevant on the issue is the inconsistency of having users with non allowed roles after we upgraded TL 1.9.14 into TL 1.9.19 => upgrade bug => report at Mantis.
Can you please confirm provided solution or provide one?
|2019-09-25 12:48||filipse||New Issue|
|2019-09-25 14:43||fman||Note Added: 0029220|
|2019-09-25 14:43||fman||QA Team - Task Workflow Status||=> TBD|
|2019-09-25 14:43||fman||Severity||minor => tweak|
|2019-09-25 14:43||fman||Description Updated||View Revisions|
|2019-09-25 16:16||filipse||Note Added: 0029223|
|Copyright © 2000 - 2020 MantisBT Team|