SSAS中用于层次结构的数据驱动安全性

I want to Implement Data Driven Security for Hierarchy in SSAS without using role.

我想在不使用角色的情况下在SSAS中实现层次结构的数据驱动安全性。

I have table like : Dimcompany, DimProduct, DimUser Table Name: DimCompany

我有像这样的表:Dimcompany,DimProduct,DimUser表名:DimCompany

CompnayId CompanyName

1 XYZ 2 ABC

Table Name : DimProduct

表名:DimProduct

Productid Productname CompanyId

1 xyx220192 1
2 xyz220193 1 3 xyz767002 1 4 abc090921 2 4 abc990099 2 4 abc202028 2

1 xyx220192 1 2 xyz220193 1 3 xyz767002 1 4 abc090921 2 4 abc990099 2 4 abc202028 2

Table Name : DimUser

表名称:DimUser

UserId UserAccount

1 Domain\User1 2 Domain\user2

1 Domain \ User1 2 Domain \ user2

Now i want to create a Data driven security in SSAS by giving access of XYZ company to User1. So that in case, in future if any new matterid insert to XYZ company, User1 will get automatically access to that matterId. I want to create a hierarchy in such way that, i want to give Company access to particular user so that user can have access to its respected matterid.

现在,我想通过向XY1提供对XY1公司的访问来在SSAS中创建数据驱动的安全性。因此,万一以后,如果有任何新的事项插入到XYZ公司,User1将自动访问该问题。我想以这样的方式创建一个层次结构,我想让公司访问特定用户,以便用户可以访问其受尊重的事项。

i have created bridge table. but user not able to access respected matterid of given company.

我创建了桥牌表。但是用户无法访问给定公司的受尊重的事项。

2 个解决方案

#1

You can't do so without roles, you need to create at least one role per company, and assign all users of that company to that role, so that users can be restricted to see data only for the company they belongs.

如果没有角色,则无法执行此操作,您需要为每个公司创建至少一个角色,并将该公司的所有用户分配给该角色,以便可以限制用户仅查看其所属公司的数据。

CompnayId CompanyName

Productid Productname CompanyId

UserId UserAccount

2 个解决方案

#1

更多相关文章

随机推荐