列RES_SECURITY_GUID在哪里？ [英] Where is column RES_SECURITY_GUID ?

问题描述

我使用Project Server 2013并希望查询每个安全组的成员。

在我搜索任何网站后，它应该查询列RES_SECURITY_GUID = WRES_GUID但我可以'在任何表格中找到RES_SECURITY_GUID。（例如，它应该在MSP.RESOURCES上）

有没有人对此问题有任何建议？

谢谢：）

解决方案

您好，

您可以尝试使用此查询搜索列名：

SELECT name FROM sysobjects WHERE id IN（SELECT id FROM syscolumns WHERE name like'％RES_SECURITY_GUID％'）

只需更改数据库名称在"可用数据库"中下拉列表。

I use Project Server 2013 and want to query member on each security group.

After I search any website, it should to query column RES_SECURITY_GUID = WRES_GUID but I can't find RES_SECURITY_GUID it in any table.(In example, it should on MSP.RESOURCES)

Could anybody have any suggestion for this problem?

Thank you :)

解决方案

Hi,

you can try with this query that searches for column names:

SELECT name FROM sysobjects WHERE id IN ( SELECT id FROM syscolumns WHERE name like '%RES_SECURITY_GUID%' )

Just change the database name in "Available databases" dropdown.

这篇关于列RES_SECURITY_GUID在哪里？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！