Re: Configuration Selection?

[Bryan Alsdorf]

Bo,

Bo Gusman wrote:
> I am logged on as the admin user and my selected project is Tech 
> Support. As per the Manage Users page, the Assigned Projects and Roles 
> show me with No Access to the Default Project and Manger access to the 
> Tech Support project. I don't see any selection option for Administrator 
> role in the dropdowns. I'm puzzled about No Access giving me _more_ 
> privilege than Manager! :)

If you have No Access to the default project, you should not be able to 
switch to the default project. Are you sure your browser is not caching 
form values? I have seen that before.

> 
> When I change my selected project to Default Project, I see that the 
> roles change: now I show as Administrator for Default Project and 
> Manager for Tech Support. I also see an Administrator option in the 
> dropdown. Resetting the TS role to Admin and selecting the TS project, I 
> now see the Configuration picks at the upper left.
> 
> I think there's an ugly implication here. If I were to delete the 
> Default Project without making me an administrator for another project, 
> what would happen? Answer: I would not be able to access the Config 
> picks. (I just did this - am I hosed? Yup, probably have to reinstall or 
> go hack the DB using phpMyAdmin! :) Seems like this ought to go pretty 
> high on your list of things to fix. My initial inclination upon 
> installation was to delete the Default Project right away after I 
> created my tech support project.

You will have to manually change this in the database. I don't think 
this happens that frequently, but it is on our list of things to fix.

In order for you to fix your user's role, please go through the
following steps:

- Get the user's ID

   SELECT usr_id FROM eventum_user WHERE
usr_email='your_email_here@stripped';

- Update the role

   UPDATE eventum_project_user SET pru_role = 7 WHERE pru_prj_id = 
PROJECT_ID_HERE AND pru_usr_id = USER_ID_HERE;

Regards,
-- 
Bryan Alsdorf, Software Engineer
MySQL AB, www.mysql.com

Are you MySQL certified?  www.mysql.com/certification