Query uses advanced features that you don’t have access to
来源:互联网 发布:淘宝怎么看物流信息 编辑:程序博客网 时间:2024/06/05 04:21
If you encounter the following message when trying to Edit or Run a specific query from Reporting Tools>Query>Query Manager:
Query “QUERY_NAME” uses advanced features that you don’t have acess to.
You are unable to access this query.
It generally means that the user’s access to query through the corresponding permission list is restricted,actually the number of joins one can perform through the query is limited and although one can run the queries with more than the number of joins this specific query has, one cannot Edit them.
Therefore, the resolution would be to go to the “Query” tab of the permission list, then to Query Profile and in the Sql Advanced Options section check the “Allow use of ‘Any Join’” box and set the “Maximum Joins Allowed” to a corresponding value (9=Unlimited number of joins) or by updating the field directly into the database:
UPDATE PS_SCRTY_QUERY SET QRY_MAX_JOINS=’9′ WHERE CLASSID=’YourPermissionList’;
It might, also, be a problem of Query Access List cache, in the context of recent modifications applied to Query Access Groups or Query Access Group settings on permission lists or roles. In order to correct or avoid the above mentioned issue one should go to PeopleTools> Security>Query Security>Query Access List Cache, check the “Enable Access List Cache” radio button and afterwards press the Run button to execute the PSQRYACCLIST application engine which will populate or refresh the query access list cache table.
- Query uses advanced features that you don’t have access to
- Error: You don't have permission to access that port.
- You don't have permission to access
- You don't have permission to access / on this server
- You don't have permission to access /*** on this server
- Wamp 报403 You don't have permission to access
- you don't have permission to access /xxx/xxx解决
- You don't have permission to access / on this server.
- You don't have permission to access on this server.
- 嵌入式 apache出现You don't have permission to access
- Forbidden You don''t have permission to access
- You don't have permission to access / on this server.
- WAMP You don't have permission to access
- You don't have permission to access ××× on this server.
- You don't have permission to access / on this server
- Wamp 报403 You don't have permission to access
- You don't have permission to access / on this server.
- Linux 之 You don't have permission to access
- Memcached 命令操作
- android - SharedPreferes
- C#端和C++端套接字通信中的几个问题
- Process Scheduler monitoring useful script
- 02_基本的UEFI架構
- Query uses advanced features that you don’t have access to
- Query security script
- 03_PEI_Phase
- 使用netlink
- 【Android】用ImageView显示本地和网上的图片
- stream
- gcc与g++
- Integration Broker “Application Message Instance Error” are not sent correctly
- htons(), ntohl(), ntohs(),htons() 函数