nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

User Authentication

ajunuthula

Hi, Is there a way that I can restrict access to the reports for different users?The following .rptdesign point to different report designs:<a data-ipb='nomediaparse' href='http://wisdom.rockefeller.edu:8080/birt/frameset?__report=Database.rptdesign'>http://wisdom.rockefeller.edu:8080/birt/frameset?__report=Database.rptdesign</a> How can theese reports be restricted access to different users. Also, is there a way that all the reports can be viewed to users with role 'admin' and few reports visible tousers with role '****' and so on. Thank you,
Aparna J

Find more posts tagged with

Comments

kclark

How will you be getting the username? Depending on how the username is received you could pass it an an encrypted hidden parameter to the report. Then the report could decrypt the username and decide if the report should be seen or forward them to an authentication error page using the text item.

ajunuthula

I am just thinking of a way, not sure if it works.I will be desiging a report with parameters username and password.Once the user enters username and password and click ok, can I issue a query to search for the user in the database table and if yes, then forward to the next report or else just go another report displaying invalid........ If this scenario does not work, am thinking of writing a servlet for user authentication: Thank you,

ajunuthula

Hi, I cannot open this link: <a data-ipb='nomediaparse' href='http://www.birt-exchange.org/org/devshare/designing-birt-reports/1542-data-engine-api-to-check-data-set-values/'>http://www.birt-exchange.org/org/devshare/designing-birt-reports/1542-data-engine-api-to-check-data-set-values/</a> I need to make sure that only certain users are able to view our BIRT reports via the web viewer.am thinking of performing the restriction within the report itself. Someone posted this article but cannot open it.

kclark

One was to do this would be with a computed column. I created a test mysql database with some usernames and password. And used this query<pre class="_prettyXprint">select username, passwordfrom user_list</pre>Then I created two parameters called username and password. Then I created a Boolean computed column that checks to see if the username/password combination provided in the parameters matches anything in the database.<pre class="_prettyXprint">if(params["UserName"].value == row["username"] && params["Password"].value == row["password"]) { true;}else{ false;}</pre>Then in the initizilize of the report I set a PGV to true.<pre class="_prettyXprint">reportContext.setPersistentGlobalVariable("fail", "true");</pre>Then created a hidden table from the username/password dataset and checked to see if any of them matched in the onCreate of the computed column.<pre class="_prettyXprint">if(this.getValue() == true) { reportContext.setPersistentGlobalVariable("fail", "false");}</pre>Finally, I check the PGV in a text item. If the PGV fail is set to true then it's forwarded to google or whatever page you want to send them to, otherwise they are welcomed.<pre class="_prettyXprint">if(reportContext.getPersistentGlobalVariable("fail") == "true") { this.text = "<html><body><script>window.location='http://www.google.com';</script></body></html>";}else{ this.text = "Welcome!";}</pre>

ajunuthula

Hi, Thank you so much for the response and I tried it but even when the password does not match, still the google url is being opened. Am trying to attach the .rptdesign but getting an error.Is there any way that I can send you the report deisgn that I created? Can you please guide me where I went wrong. Thank you.

kclark

From our conversation in email the solution to this was to put<pre class="_prettyXprint">if(reportContext.getPersistentGlobalVariable("fail") == "true") { this.text = "<html><body><script>window.location='http://www.google.com';</script></body></html>";}else{ this.text = "Welcome!";}</pre>In the onCreate() of your text item.