Forum

Rights access
 
Notifications
Retirer tout

Rights access

16 Posts
2 Utilisateurs
0 Reactions
8,240 Vu
(@bonga)
Posts: 25
Eminent Member
Début du sujet
 
[#5276]

I was setting up rights allocation as administrator for the users. However, after saving I was locked out to do other activities such as report access, it won't allow me to access users and so on. How does the administrator have global rights unlike employees?


 
Posté : 13/07/2018 6:06 pm
(@babynus)
Posts: 14952
Membre Admin
 

How does the administrator have global rights unlike employees?

It's ProjeQtOr default configuration behaviour

You should have changed things on rights management.
Please post screenshots to explain your issue.


 
Posté : 13/07/2018 8:24 pm
(@bonga)
Posts: 25
Eminent Member
Début du sujet
 

How does the administrator have global rights unlike employees?

It's ProjeQtOr default configuration behaviour

You should have changed things on rights management.
Please post screenshots to explain your issue.

I was on the forms to give different rights and saved and it also locked me out as administrator out. For examole, no one now is able to access access forms to grant to take away rights and so on. I have attached a screenshot of things I have access to and the global aooaratus which should take me to where in grant access rights is not there. I need to know how to restore it.


 
Posté : 14/07/2018 11:26 am
(@babynus)
Posts: 14952
Membre Admin
 

HI,

You have to retore right for admin directly in database.

UPDATE habilitation SET allowAccess=1 WHERE idProfile=1 and idMenu=(SELECT id FROM menu WHERE name ='menuHabilitation');

 
Posté : 15/07/2018 10:16 pm
(@bonga)
Posts: 25
Eminent Member
Début du sujet
 

Can you please take me through the steps on how to restore right for admin directly in database?


 
Posté : 16/07/2018 3:58 pm
(@babynus)
Posts: 14952
Membre Admin
 

Execute SQL query proposed on prior post


 
Posté : 16/07/2018 4:04 pm
(@bonga)
Posts: 25
Eminent Member
Début du sujet
 

How do i get to the database in order to execute the SQL query on the database ?


 
Posté : 16/07/2018 5:37 pm
(@babynus)
Posts: 14952
Membre Admin
 

either use mysql commande or install phpMyAdmin or use external tool (such as toad for mysql)


 
Posté : 17/07/2018 3:36 pm
(@bonga)
Posts: 25
Eminent Member
Début du sujet
 

i have got phpMyAdmin installed, now where do i put the command in phpMyAdmin ?


 
Posté : 17/07/2018 3:58 pm
(@babynus)
Posts: 14952
Membre Admin
 

Select you db on left part
Select tab "SQL"

NB : if you're not confident with using SQL commands, please backup your DB before (TAB export)


 
Posté : 17/07/2018 4:15 pm
(@bonga)
Posts: 25
Eminent Member
Début du sujet
 

Here is a screenshot of what i see on phpMyAdmin


 
Posté : 17/07/2018 4:31 pm
(@babynus)
Posts: 14952
Membre Admin
 

You have to select your projeqtor db on the left then SQL tab on top.
If you're not fluent with use of phpMyAdmin, try a tutorial for it, there are many on the web.


 
Posté : 17/07/2018 5:08 pm
(@bonga)
Posts: 25
Eminent Member
Début du sujet
 

I have looked at the tutorials online and i have seen how its done but i just want to make sure if the script you gave me previously to type on the database is correct and i may just copy it and past it there and execute it ?


 
Posté : 19/07/2018 10:55 am
(@babynus)
Posts: 14952
Membre Admin
 

i just want to make sure if the script you gave me previously to type on the database is correct and i may just copy it and past it there and execute it ?

Is it really a question ?

Do you think I took time to answer your request to finaly give you some bullshit script ? :angry:


 
Posté : 19/07/2018 7:27 pm
(@bonga)
Posts: 25
Eminent Member
Début du sujet
 

When i run the script i am getting this error can you assist


 
Posté : 23/07/2018 10:49 am
Page 1 / 2
Share:
Retour en haut