Automatically add resource to category

[James]

Hi,

How do I associate a user with a category in Project Server if I want to
create the entries directly in the tables in the Project Server SQL
database? I'm confused by the relationship between the various tables. I
previously did something similar for projects, and it was simply a case of
adding a row to MSP_WEB_SECURITY_OBJECTS but it seems to a bit more
complicated for a user and involves the MSP_WEB_SECURITY_SP_CAT_RELATIONS
table.

Am I on the right lines?

Regards,

James

 

[Ed Morrison]

You may be confusing adding a resource object to a category and giving a
user permissions against objects in the category.

If you are trying to add a resource object to a category, it is added the
same way a project is added. In the MSP_WEB_Security_Category table, add a
row with the appropriate wsec_cat_id, wsec_obj_type=2, and wsec_obj_id is
the wres_id from msp_web_resources.

Hope this helps.

 

[James]

Yes Ed, this is what I wanted, sorry if my description was a bit confusing.
It's a complicated database!

James