This topic is locked
[SOLVED]

 single sign on and view data

4/22/2010 3:31:00 PM
ASPRunnerPro General questions
Z
zion4ever author

Hello all,
I have a question. I am using my own asp pages for username and password management, login,etc. I use ASPrunner to help me create pages for my database quickly. In order to use the ASPrunner security feature "users can view and edit own records only", I created a login page. But I don't use it. I override it with the following code in Beforeprocess on the Login Page:
If session("IsLoggedIn") = "" Then

response.redirect "nologin.asp"

else

SESSION("UserID") = session("USER") 'Session("User") is created when the user logs in on the main page succesfully

SESSION("AccessLevel") = ACCESS_LEVEL_USER

Response.Redirect "correspondentie_list.asp"

end if
Now all sessions are created succesfully. However, it says no records found. So i tested it, thinking i might have setup the relation current table-->main table ownerid wrong. I removed the above code and just logged in with a username and password from the db through the asprunner loginpage. What do you know; it works then.
So my question is, if I overrule the login page with single sign on, how come the "users can see only their own data" feature doesn't work anymore and how can i fix it.
TIA'
Hans

Sergey Kornilov admin 4/22/2010

You need to fill SESSION("_<table name>_OwnerID") session variable for each table that uses "users can see only their own data" option.
More info:

http://xlinesoft.com/asprunnerpro/docs/asprunner_session_variables.htm

Z
zion4ever author 4/23/2010



You need to fill SESSION("_<table name>_OwnerID") session variable for each table that uses "users can see only their own data" option.
More info:

http://xlinesoft.com/asprunnerpro/docs/asprunner_session_variables.htm


Hello admin, thank you for your swift reply. I have already experimented with it as you said. Was triggered by the aspr manual. But couldn't get it to work as I only did it for one table. Your remark about doing it for each table was invalueable.
Thank you
Hans