Developers Access Level

[Darrell]

Working as a Controls Specialist I need to involve a developer in creating
some custom views, reports, etc. What access do I need to request from the
Project Server Admin to make sure the developer can go and do whatever he
needs too?

thx,
Darrell

 

[Jack Dahlgren]

I'd give the developer administrator privileges. You may get away with some
trimmed down permission set, but it would be much easier to just add them to
the administrators group instead of building a permission set from scratch.
For example, determining the permissions required to "etc." is a hopeless
task. I wouldn't waste time on that. Why risk having your developer idle for
hours unable to do what they are supposed to?

-Jack Dahlgren

 

[Darrell]

Jack,

Thx for the response. This is my first trip to the developer side of Project
Server, as well as the developer assigned to help me, so we have been doing a
ton of reading but the answers are not always easy to find. In the article
about setting up a development environment is states "Note: you need a server
account and the proper permissions" but fails to state which permissions.
And, like you I would just grant full Admin permissions but I have to go thru
an DBA group who thinks the rest of us live to destroy databases.

Again thx for the info,
Darrell

 

[Jack Dahlgren]

For views and reports on Project Server PWA (Project Center, Resource Center,
Data Analysis) you only need admin on Project Server. This does not give you
access to trash the databases. It is primarily application configuration.

If you are doing custom reporting and writing addition reports using SSRS or
some other tool, then you may need further access to databases and to the
report server if you have one.

For any further development, I'd ask the developer to tell me what access
they need. If they don't know that, you really don't want them working on
your database.

What sort of customization is going to be done?

-Jack Dahlgren

 

[Darrell]

Jack,

The first thing I need is to access the Assignment Transaction history
tables because we have a circular complaint about who is not doing their part
in updating, i.e. the PM says I do not update the tasks because I do not
receive updates from the resources, the resources say they do not update the
tasks because the schedules are not up-to-date. This excuse for not using the
tool has been going on for several years before I arrived so I am climbing
uphill all the way trying to end this cultural dispute. I originally created
an Access db and ran a report showing a lack of delta on the Remaining Work
field for active tasks and because it only showed no update was applied
versus who failed to do their part, the report quickly fell into disuse (too
much trouble to track down the culprit, go figure). Anyways, I now have to
access the Published db to get the transaction history to finally put an end
to this issue.

I then have a punch list of smaller issues I want to address. Being an IT
org I shouldn’t be having this much trouble getting these things done, but
then again if things weren’t broken here I probably wouldn’t have a job
<grin>.

Thx again,
Darrell