sirs, just an addition, the solution might seem to work with tables inside the DNN database. I have another database with all the stuff i need. the user-id/roles are in the DNN database.

My portal works like this:

Employee gets in the main portal, clicks on my portal, and SAP throws an encrypted string of the info of the employee. Once I decrypt it, then will I get the unique employee number. As much as possible, there SHOULDN'T be any registering in dotnetnuke (so no userID then for dotnetnuke) and again, I'll be using the employee number or whatever credential from that string, to query another database using the module sqlgridselectedview that I eventually asked about dynamically changing its query statement.

so sirs, will this be possible? or is it really necessary that I put the tables of my existing database into DNN database so I can use this solution, provided I also need employees to register and login to the portal? so the main questions are:

1. how do I handle the dynamic querying by passing info I decrypted, without using a userId from DNN?

2. If this is not possible, then should I put my database in DNN database AND have employees register still (that is not quite acceptable in the business requirement specified)

sorry for bugging too much, I'm in a hurry reading this and that implementing this and that and not seeing what I need. So please enlighten me once again sirs. Sir paul I know your busy but I hope you could find a few minutes. thanks so much!