View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Access rights - ProjeQtOr
 

Access rights

More
02 Jan 2023 19:18 #1 by kobetsu
Access rights was created by kobetsu
Hello,

Happy New Year BTW,

Using views of "AccessProfileAll" and "AccessRight" I'm able to build map of rights associated with given profile but I cannot access rights collected in UI
as "Specific access", "Access to reports", "Access to forms".

Please tell me in which DB view I can find info about:
a. "Specific access" of given profile
b. "Access to reports" of given profile
c. "Access to forms" of given profile
 

Please Log in or Create an account to join the conversation.

More
03 Jan 2023 09:31 #2 by babynus
Replied by babynus on topic Access rights
a. "Specific access" of given profile => habilitationother
b. "Access to reports" of given profile => habilitationreport
c. "Access to forms" of given profile => habilitation

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
03 Jan 2023 09:42 #3 by kobetsu
Replied by kobetsu on topic Access rights
Thanks.
One more question...
In view "AccessProfileAll" and similar like "AccessProfileNoProject" seems there is no clear separation between ProjectDependend and ProjectNotDepended access rights. Looks like I have to use "AccessProfileAll".
Is there a view getting only info about ProjectDepended and another view of ProjectNotDependent access right ?
I see field "isNonProject" but looks like it is not accessible.

Please Log in or Create an account to join the conversation.

More
05 Jan 2023 14:11 #4 by babynus
Replied by babynus on topic Access rights
AccessProfile : for project dependant
AccessProfileNoProject : for non project dependant
AccessProfileAll : for both

Note that there are profiles with same names in first and second, but they have different ids

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
07 Jan 2023 21:30 - 08 Jan 2023 10:28 #5 by kobetsu
Replied by kobetsu on topic Access rights
1.
In rights of given profile I found right described as "Global view" which is stored in "AccessProfile" (project dependend) but I do not see this right in PQ in administrator/Access to data (project dependant) view. I found it in "habilitation".
So looks like "Global view" exists (in DB) in "habilitation" and in "AccessProfile".

Am I right that this one in "AccessProfile" is garbage ?
If YES, is it danger for pq stability ? Is there any tool to clean up such garbages ?

2.
Additionally, I see we have in out db profiles (habilitation table) which does not exist in the table AccessRight.
These profiles have id and name with the same value (numerical).
Looks like some garbages.
Is it danger for projeqtors stability ?
Is there any process we can clean up such items ?

3.
Additionally, I see we have in our db duplication of records in table habilitation - means - there are double records for idMenu=263 (nameMenu = "Translations").
I suppose projeqtor take first occurence to get info about rights.
Looks like some garbages.
Is it danger for projeqtors stability ?
Is there any process we can clean up such items ?

4.
Additionally I see we have in our db, in table "habilitation" record with nameManu = "Financial" which seems does not exist in PQ UI / Access to forms.
Looks like some garbages.
Is it danger for projeqtors stability ?
Is there any process we can clean up such items ?
 
Last edit: 08 Jan 2023 10:28 by kobetsu.

Please Log in or Create an account to join the conversation.

More
14 Jan 2023 10:29 #6 by kobetsu
Replied by kobetsu on topic Access rights
Any response ?

Please Log in or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.050 seconds

Cookies settings

×

Functional Cookies

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Please login to see yours activities!

Other cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.