Resource security attributes

[Johnnie Rotten]

Hello,

We've been looking over the database schema document and have failed to find
the table(s) containing information on what security attributes a resource
has.

Such as group memberships or category associations.

Project Server is running in Enterprise mode and Windows NT authentication
is enabled.

We would like to configure a trigger to monitor the security attribute
table.

Thanks!!!

 

[Dale Howard [MVP]]

Johnnie --

Are you looking at the weberd.htm file? In the weberd.htm file, there is a
large section devoted to the MSP_WEB_SECURITY tables in the bottom middle of
the database schema. Hope this helps.

 

[Johnnie Rotten]

I visited the MSFT downloads page and specified "schema" for the keyword and
"project" for the product. The resulting query had the client & web
database schema as hits, and I downloaded them both.

Sure enough, in the middle & toward the bottom the schema diagram had all
the security tables grouped together.

Thanks Dale!

 

[Dale Howard [MVP]]

Johnnie --

You are more then welcome, my friend!