Solved

Report Builder 1.0

Posted on 2014-02-26
2
398 Views
Last Modified: 2014-03-13
I am working on Report Builder 1.0 AdHoc Reporting tool and want to implement Security/ Entitlements on the Tables/ data that the users can access. I cannot use multiple logins. I have a table that has the UserID and the RegionID.

I want to restrict the users to data for only the region that they are entitled for and return the data to them through AdHoc Reporting. Anyway to build this security/ Entitlements is highly appreciated.
0
Comment
Question by:Rdichpally
2 Comments
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 39892512
Are the users logging into the application?

How are you getting the user id for the one running the report?

Assuming you can use the UserID/Region table to link to the rest of the data just create a where clause like

UserLoggedIN = UseridTable.UserId

Link the regionid from the table to the rest of the tables and it should take care of the security

mlmcc
0
 

Author Closing Comment

by:Rdichpally
ID: 39927134
Thanks
0

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Article by: btan
Provide an easy one stop to quickly get the relevant information on common asked question on Ransomware in Expert Exchange.
Encryption for Business Encryption (https://en.wikipedia.org/wiki/Encryption) ensures the safety of our data when sending emails. In most cases, to read an encrypted email you must enter a secret key that will enable you to decrypt the email. T…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now