This content has been marked as final. Show 5 replies
Have a look at the following section of PeopleBooks:
PeopleBooks > PeopleTools 8.52: BI Publisher for PeopleSoft > Setting Up BI Publisher > Assigning BIP Permissions to Users
PeopleBooks > PeopleTools 8.52: BI Publisher for PeopleSoft > Defining Report Definitions > Assigning Report Viewers at Runtime
Thanks for the Reply.
from the doc. you gave, this is what i found.
Home > PeopleBooks > PeopleTools 8.52: BI Publisher for PeopleSoft > Running, Locating, and Viewing BI Publisher Reports
The Query Report Viewer allows selection and online viewing of those reports that have a data source type of PeopleSoft Query. Existing Query security applies so that each user has access to run only the reports to which he or she has qualified Query access to the data source.
The PS query and the data source is created by user PS then how can a normal user will have access to that?
I'm bit confused here.
You are mixing up things. Query access provide access to tables and views. Public queries created by any user are executable for all users that have access to the tables and views used in the query.
Sorry.Yes i got that. The Query Security tree makes available views,records in a query.
Actully my point is the view behind the search button(query report viewer) using two tables which uses oprid in where clause for table PSXPRPTDEFN and PSXPDATASRC.
Both table oprid is null for report definition and data source. so how query will satisfy output?
Thanks & Regards!
I was able to solve the problem by adding child record instead a child group to main access group.