Submit Your Suggestions for Vista

Ideaspace topics with the most votes have been moved into the Suggestion Box. If there is a topic missing, please re-enter. Our product team reviews the Suggestion Box items regularly and will provide updates as to status and incorporation into upcoming releases.

• Home /
• PF-I-490 /
• New Suggestion

3 Vote

VA Data Security is not observed when running SSRS reports

VA Data security is not observed when running SSRS Reports which use data types that have been secured.

STEPS TO REPRODUCEIn the customer's environment, VFC (US Shale), using domain logins to access SSRS Reports Server. In the RP RS Server form, sync security is selected. VA Data security is set to lock down HQCo, with Security group 10000 as default. Other groups, 10001 for company 1 and 10201 for company 201. User "vptest" is part of 10001 only. Adding a reports work center for vptest, the company selection does observe that this user only has access to company 1. Adding an SSRS report for say jobs or contracts, vptest can see all companies in the company drop down and can see all contracts for this company. And vptest can see results for this report. CURRENT RESULTSAdding a reports work center for vptest, the company selection does observe that this user only has access to company 1. Adding an SSRS report for say jobs or contracts, vptest can see all companies in the company drop down and can see all contracts for this company. And vptest can see results for this report. EXPECTED RESULTSUser vptest should only see company 1 in the SSRS report drop down and all contracts or jobs which are only in company 1. WORKAROUNDIt appears that when users are given access to the Viewpoint database out in the SSRS reports server, this circumvents any security settings back in Viewpoint, data security access. The sync security check box in RP RS Server should only control report access. In VA data security access, is this info written to the OLAP BI cube, where SSRS reports are looking? Should the OLAP cube be processed when significant data security settings are implemented.

• Andrew Karr
• May 25 2017

Vista Apps / VA - Vista Admin

Company	EMCOR
Job Title / Role	IT Mgr
I need it...	Yesterday...Come on already

• Comments (0)
• Votes (3)

• Attach files

  Enter a subject

• 
• 
• 

Log in / Sign up

Identify yourself with your email address

Email address

Subscribe

You won't be notified about changes to this idea.

Related Suggestion

Dear Viewpoint Suggestion Box contributor;

We at Viewpoint sincerely thank you for your contribution to Suggestion Box on how we can improve Viewpoint products. While we can’t do everything at once, we rely upon your feedback to help guide the prioritization of our product improvements, and Suggestion Box is a critical tool for us to understand and prioritize our customers’ needs. Viewpoint reviews Suggestion Box regularly for all of our products and updates statuses, adds comments, and performs various house-keeping (including deleting) as needed to ensure that Suggestion Box is maintained as a productive environment for product enhancements requests.