authentication using database users

[ibrahimhamza]

Hi All

I installed jasperserver using the installer

it really works out of box

But in our work we have already physical database users

and I want to authenticate from database

Is it applicable and how?

Post Edited by ibrahim hamza at 04/07/09 11:32

[anandharaj]

Well, you can configure JS to authenticate to your LDAP, but if its just a plain DB with some users, i dont think so. Some more JS has its own password encryption method, if your DB store the password in plain/MD5 hash, it will not able to authenticate. What you can do is, import all this user to JS.

Sherman / Lucianc, correct me if im wrong

Post Edited by Anandharaj @ Raj at 04/09/09 03:01

[ibrahimhamza]

Thanks anandharaj

I don't have ldap

I have oracle XE database which contains the repository

I want to authenticate from physical database users

just connect to oracle using jdbc

oracle save passwords in its own way

 

Post Edited by ibrahim hamza at 04/08/09 09:21

[ibrahimhamza]

Is this applicable to connect using database users

[anandharaj]

Hi ibrahimhamza,

 

What you can do is synchronize the user details to JasperServer (using trigger)and make sure password encryption are same in both database.

[ibrahimhamza]

thanks anandharaj for your great support and your good response

but oracle save passwords in its own way

i try now to save the users passwords that will connect to the reports in standard hasing like sha1 or md5

and if i find a solution for databse users i will post it here

[swood]

You can do this by implementing an Acegi bean that does the authentication on login by trying to connect to an Oracle instance with the supplied user name and password.

 

You may also need a custom data source that connects to the database as the users when you run reports . This would cover the case where you have database level security.

 

Sherman

Jaspersoft