<div>
<div class="content wysiwyg-content">
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. <br />
<br />
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.
</div>
</div>


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.

Report Builder 1.0

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

Security is the protection of information systems from theft or damage to the hardware, the software, and the information on them, as well as from disruption or misdirection of the services they provide. The main goal of security is protecting assets, and an asset is anything of value and worthy of protection.  Information Security is a discipline of protecting information assets from threats through safeguards to achieve the objectives of confidentiality, integrity, and availability or CIA for short. On the other hand, disclosure, alteration, and disruption (DAD) compromise the security objectives.