Can we use database table in DB2 to store usernames,pswds and userclas

[mvchaudhari]

Can one use a database table in DB2 to store user names, passwords and user classes or do he has to use an LDAP?

 

[GJParker]

If your suign IWR, PPES, Upfront thnen you need to use LDAP of LAE file. don't use Reportnet so I can't comment.



Gary Parker
MIS Data Analyst
Manchester, England

 

[winkid1]

I believe all security info has to be in an LDAP. You can then use the parameters in ReportNet to filter the reports based on a security table in your database. For example, to pull the user that logged into ReportNet, you would use
#sq($account.personalInfo.userName)# in a calculation/filter, and then match that up with your security objects in the table and restrict the data that way. Of course, that's just one example, and there are probably better ways to utilize the security data.

Hope that helps.