Query for security info....what is the correct table name?

[JodyJ]

I have taken an initial stab at our security setup and would like to share
this info with other stakeholders for their approval. I was trying to be
efficient and just query the database for this info and then dump it to Excel.

I found the table that contains my Groups (msp_web_security_groups) but I
can't find the table(s) that actually contain the info re: each feature and
whether it is allowed, disallowed or denied. Seems like this should be
pretty obvious but I'm stumped.

Does anyone know which table this info is housed in?

 

[Dale Howard [MVP]]

JodyJ --

You would be far better off printing the information in Appendix D of the
Microsoft Office Project Server 2003 Administrator's Guide, available for
free download at:

http://www.microsoft.com/downloads/...40-147b-447a-b0d3-6088673a53a4&DisplayLang=en

Hope this helps.

 

[JodyJ]

Thanks...I'm not looking for the default settings though. I want a query of
what I've set up for our organization.

 

[Dale Howard [MVP]]

JodyJ --

Download the Project Server 2003 database schema at the following URL:

http://www.microsoft.com/downloads/...75-1367-4b66-870d-f280c054efe2&DisplayLang=en

Refer to the Security tables information in the bottom middle of the schema
for the security relationships you seek to query. Hope this helps.

 

[JodyJ]

Thanks...that might help me.

JodyJ --

Download the Project Server 2003 database schema at the following URL:

http://www.microsoft.com/downloads/...75-1367-4b66-870d-f280c054efe2&DisplayLang=en

Refer to the Security tables information in the bottom middle of the schema
for the security relationships you seek to query. Hope this helps.