Forum

Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.

Rights access
 
Notifications
Clear all

Rights access

16 Posts
2 Users
0 Reactions
8,242 Views
(@bonga)
Posts: 25
Active Member
Topic starter
 
[#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?


 
Posted : 13 Jul 2018 18H06
babynus
(@babynus)
Posts: 14957
Main Contributor 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.


 
Posted : 13 Jul 2018 20H24
(@bonga)
Posts: 25
Active Member
Topic starter
 

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.


 
Posted : 14 Jul 2018 11H26
babynus
(@babynus)
Posts: 14957
Main Contributor 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');

 
Posted : 15 Jul 2018 22H16
(@bonga)
Posts: 25
Active Member
Topic starter
 

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


 
Posted : 16 Jul 2018 15H58
babynus
(@babynus)
Posts: 14957
Main Contributor Admin
 

Execute SQL query proposed on prior post


 
Posted : 16 Jul 2018 16H04
(@bonga)
Posts: 25
Active Member
Topic starter
 

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


 
Posted : 16 Jul 2018 17H37
babynus
(@babynus)
Posts: 14957
Main Contributor Admin
 

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


 
Posted : 17 Jul 2018 15H36
(@bonga)
Posts: 25
Active Member
Topic starter
 

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


 
Posted : 17 Jul 2018 15H58
babynus
(@babynus)
Posts: 14957
Main Contributor 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)


 
Posted : 17 Jul 2018 16H15
(@bonga)
Posts: 25
Active Member
Topic starter
 

Here is a screenshot of what i see on phpMyAdmin


 
Posted : 17 Jul 2018 16H31
babynus
(@babynus)
Posts: 14957
Main Contributor 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.


 
Posted : 17 Jul 2018 17H08
(@bonga)
Posts: 25
Active Member
Topic starter
 

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 ?


 
Posted : 19 Jul 2018 10H55
babynus
(@babynus)
Posts: 14957
Main Contributor 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:


 
Posted : 19 Jul 2018 19H27
(@bonga)
Posts: 25
Active Member
Topic starter
 

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


 
Posted : 23 Jul 2018 10H49
babynus
(@babynus)
Posts: 14957
Main Contributor Admin
 

Chezck table names, possibly you added a prefix.
You'll then have to change the table name in the script.


 
Posted : 23 Jul 2018 11H02
Share:

Scroll to Top