Hidden task and project access

D

Darek

I have a "test" project with a few tasks. To two task I
assigned a the same resource - "res". I published project.
Then I decided to remove "res" from the tasks (and I
removed resource from the Team with Build Team from....).
I logged on to Web Acess with "res" account. I went to
Task menu. There were two removed tasks. I hid them.
Now "res" does not participate in the "test" project.
However in Project Center I still can see the "test"
project.
Is there a way to make "test" project non accesible
for "res" ? Does the only way is to manually delete hidden
tasks in project database ?

I really appreciate you help and comments about it. Thanks.
 
B

Brian K - Project MVP

Darek said:
I have a "test" project with a few tasks. To two task I
assigned a the same resource - "res". I published project.
Then I decided to remove "res" from the tasks (and I
removed resource from the Team with Build Team from....).
I logged on to Web Acess with "res" account. I went to
Task menu. There were two removed tasks. I hid them.
Now "res" does not participate in the "test" project.
However in Project Center I still can see the "test"
project.
Is there a way to make "test" project non accesible
for "res" ? Does the only way is to manually delete hidden
tasks in project database ?

I really appreciate you help and comments about it. Thanks.
Click to expand...

Open the project and "Publish New and Changed Assignments". Until the
changed assignments are published again Project Web Access will still
think that Res is assigned to those tasks. Hiding them from the
timesheet does not remove Res from the project.
 
D

Darek

-----Original Message-----
Thanks.

Open the project and "Publish New and Changed Assignments". Until the
changed assignments are published again Project Web Access will still
think that Res is assigned to those tasks. Hiding them from the
timesheet does not remove Res from the project.
Click to expand...

I published "test" project with "All information" option.
No change.
In "test" project "res" has no other task assignments, but
still can access "test" project.
I wonder if that situation is normal because if you do not
have any task assignments and the task assignments you had
are no more, in my opinion you should not have an access
to this project - even if the removed tasks were hidden.

What do you think of it ?
 
B

Brian K - Project MVP

Darek said:
I published "test" project with "All information" option.
No change.
In "test" project "res" has no other task assignments, but
still can access "test" project.
I wonder if that situation is normal because if you do not
have any task assignments and the task assignments you had
are no more, in my opinion you should not have an access
to this project - even if the removed tasks were hidden.

What do you think of it ?
Click to expand...

Remove the Resource from the Resource Sheet of the Project.
 
D

Darek

-----Original Message-----


Remove the Resource from the Resource Sheet of the Project.

--
Click to expand...

I did it. No change.
I'm afraid there are three choices:
1. Delete all task of that "resource" from project server
and then republish its task assignments once more.
2. Delete that "project" and import it once more.
3. Remove all hidden tasks assignmnets of that "resource"
from project database. I think they should be removed from
MSP_WEB_ASSIGNMENTS table. Do you know what other tables I
should remove hidden tasks from ?

Thanks for your time.
 
B

Brian K - Project MVP

Darek said:
I did it. No change.
I'm afraid there are three choices:
1. Delete all task of that "resource" from project server
and then republish its task assignments once more.
2. Delete that "project" and import it once more.
3. Remove all hidden tasks assignmnets of that "resource"
from project database. I think they should be removed from
MSP_WEB_ASSIGNMENTS table. Do you know what other tables I
should remove hidden tasks from ?

Thanks for your time.
Click to expand...

Try publishing just the "new and changed assignments"
 
D

Darek

-----Original Message-----


Try publishing just the "new and changed assignments"

--
Click to expand...

It didn't work.
How about the three choices mentioned in my previous
message.
Which of them in your opinion is the most secure the most
comfortable to use ?
 
B

Brian K - Project MVP

Darek said:
It didn't work.
How about the three choices mentioned in my previous
message.
Which of them in your opinion is the most secure the most
comfortable to use ?
Click to expand...

Well number 1 was what I thought you said you already did so I would go
with that one. :)
 
D

Darek

-----Original Message-----


Well number 1 was what I thought you said you already did so I would go
with that one. :)
Click to expand...

About number 1 :),
On Clean Database page in PWA I can choose "Tasks", then
specify range and resource and... it would be good to have
passibility to specify a project from which I would like
to delete these tasks.
Do you happen to know a SQL procedure which could do that ?
Or maybe one of the Stored Procedures from Project Server
database would be just fine (well, maybe after little
modification)?

Sorry, for being są stubborn about this subject :) but I
really want to solve the problem as best as it is possible.

thanks for your patience.
 
Top