I have a table that holds data for each user(password,name,email address, etc.) When a user starts the application they type in a password which either lets them continue if they are vaild users or the app goes no further if it can't find the password they entered.

My design question is this. I need all the peices of data on the logged on user at various stages in my app to verify which functions are open to them since authoriy varies between users. Do I create a cursor based on the user after the password is verified and use the cursor results throughout my app? Or do I set up Public varibles based on the cursor results?

Whats the best way to handle this? One note is at some points in my app I push data to remote tables. When this happens I have to close my tables in the DE and then open them again. Won't this kill my cursor?