Reporting Security Settings

J

Jim Sipe

In ProjectServer 2007, is there a way to develop a report showing all
security settings, e.g.

A report that shows all users and "what they can see and what they can do"
based on their group and category settings.

Thanks
 
J

James Fraser

In ProjectServer 2007, is there a way to develop a report showing all
security settings, e.g.

A report that shows all users and "what they can see and what they can do"
based on their group and category settings.
Click to expand...

The information is all in the SQL databases, particularly the
published database. So a report like this can be developed. One of the
easiest ways to figure out the DB structure is create a new user as a
test case and watch what happens as you add and remove groups and
permissions. The tables are usually named in a self-explanatory
manner.

Of course, keep in mind that MS doesn't encourage/support using the
databases for reporting other than the documented reporting database.


James Fraser
 
Top