Demo Instruction:
假定CustomerID > 100的为VIP客户,我们的权限设置为只显示VIP客户
所使用的Attribute View: ATTR_CUSTOMER_FULLADDRESS
http://www.cnblogs.com/omygod/archive/2013/04/29/3050424.html
1. 在Content右键创建Analytic Privilege:
![](https://images0.cnblogs.com/blog/18408/201305/01053155-65d4ee460e374a9184cfa965eaffe1ba.png)
设置基础信息:
![](https://images0.cnblogs.com/blog/18408/201305/01053157-5fe33b506a434e75adb404be964f9167.png)
选择需要权限控制的视图:
![](https://images0.cnblogs.com/blog/18408/201305/01053159-0ba898e603db440f8d795ba69d73aff7.png)
点击Finish进入设计主界面:
![](https://images0.cnblogs.com/blog/18408/201305/01053201-0aaad22496fe4073b291a04aa3e6aec4.png)
2. 添加 Associated Attributes Restrictio
点击Add 按钮:
![](https://images0.cnblogs.com/blog/18408/201305/01053203-e1773e6f5f4a43a59c0876e773af00b4.png)
选择需要限制的字段:
![](https://images0.cnblogs.com/blog/18408/201305/01053205-a5136ee18e184d26a75504f082c483c5.png)
OK之后如下界面:
![](https://images0.cnblogs.com/blog/18408/201305/01053207-ae75115f02c24b97b6dd2b1be8686ecf.png)
选中刚刚添加的字段,点击正下方的Add 添加Assign Restrictions,添加一个限制条件:
![](https://images0.cnblogs.com/blog/18408/201305/01053208-ec0e2a7ce59c45dfb21e58d0c5936ce8.png)
3. 保存并激活
4. 将Analytic Privilege授权给某一特定用户
新建用户CUSTOMER_VIP_ADMIN,并作如下授权:
新建用户的默认Role:
![](https://images0.cnblogs.com/blog/18408/201305/01053209-8947131282e14fbe8ff43ad972b7c8b4.png)
SQL Privileges: 主要需要授权能访问的视图存储器和视图:
![](https://images0.cnblogs.com/blog/18408/201305/01053211-f4f3f378cf104cd080b94e8100746696.png)
![](https://images0.cnblogs.com/blog/18408/201305/01053213-f341f79650464ba8938fb8d188df2dc2.png)
![](https://images0.cnblogs.com/blog/18408/201305/01053214-6cdf9245cc084a0b866cc543fb0eea29.png)
Analytic Privileges: 分析权限
![](https://images0.cnblogs.com/blog/18408/201305/01053216-c9505d0ca1bd4aedb0215d1c18ed670c.png)
Package权限:
![](https://images0.cnblogs.com/blog/18408/201305/01053218-34c725c1c65c4a8d94ee2c5355cd6745.png)
5. 测试分析权限是否正确:
在System 用户的情况下(无分析权限限制):
![](https://images0.cnblogs.com/blog/18408/201305/01053222-3594208b99ee455d94289c04d219f903.png)
有权限限制的情况下(CUSTOMTER_VIP_ADMIN):
![](https://images0.cnblogs.com/blog/18408/201305/01053225-8bca73e6d32b4dc1b7e884f3b4583266.png)
原文地址: https://www.cnblogs.com/omygod/archive/2013/05/01/3052739.html