Need a special offer?Find out if your project fits.
+

I am trying to restrict access to data based upon database security

Answered
Douglas Reed asked on March 18, 2016

I am in the process of evaluating Flexmonster for use in our business.
We are using a Postgres database (in this case version 9.5) and want to restrict access to certain parts of data using row level security.
In the HTML client startup file, I have added the credentials data (see below) but when I monitor the access to the database, it is using the credentials from the server process, not the client.
I believe that the credentials data is being ignored when the client starts up, even if I mis-spell the elements the model still loads up and runs without complaining
<script type="text/javascript">
var config = {
licenseKey: "Z526-0K1NY2-2L2Q-3H09-0H1N-1W0C-141V-162H-1V13-0T",
dataSourceType: "mondrian",
proxyUrl: "http://localhost:50006/FlexmonsterProxy",
catalog: "caerus_reporting.xml",
cube: "Bet",
binary: true,
credentials: {
username: "dr_rep",
password: "dbr012"
}
}
flexmonster.embedPivotComponent("flexmonster/", "pivotContainer", "100%", "615", config, true);

Also, are there any load limitations, the application sometimes hangs when I drill down into larger quantities of data?

Regards

3 answers

Public
Ian Sadovy Ian Sadovy Flexmonster March 18, 2016

Hello,
 
Thank you for the question.
There is a mistake in our documentation regarding credentials, please try the following code:

var config = {
...
dataSourceType: “mondrian”,
proxyUrl: “http://localhost:50006/FlexmonsterProxy&#8221;,
catalog: “caerus_reporting.xml”,
cube: “Bet”,
binary: true,
username: “dr_rep”,
password: “dbr012″
}
...

Hope this helps.
 
Regards,
Ian

Public
Douglas Reed March 18, 2016

Many thanks

Public
Tanya Gryshko Tanya Gryshko Flexmonster December 5, 2016

Hello Douglas and all Flexmonster users,
In version 2.3 Report Object was structured. Properties were logically grouped into sub-objects. For example, all related to data sources properties are inside dataSource sub-object now. Find more details in the documentation: Report Object.
Regards,
Tanya

Please login or Register to Submit Answer