2. ASPRunnerPro General questions
  3. V5.2, “Edit” shown when user permission is “View Only”
This topic is locked

V5.2, “Edit” shown when user permission is “View Only”

 		5/2/2008 2:42:14 PM
ASPRunnerPro General questions
X
 xitedaz author

Some time ago I tested ASPRunner 5.1 and by the time we decided to purchase - the ASPRunner 5.2 was released so we downloaded it to see if we still want to purchase. From that I have basically 2 questions.
The first of the 2: When I did a build on the same project as was completed with 5.1 the results seem to be different. The 5.1 test project used "static" permissions as follows:
Our database needs consists of an initial db entry in 3 phases with different users for each phase which are not allowed to change the other user's entries and with Admin ability to edit / change all entries. Phase 1 to 3 "Views" of the main table were created as well as an "Edit All" view from the main table for Admin.
As I could not figured out how to have different tables for the different users of admin, class, and/or phases (as was the case in my own ASP interface I wrote) all users were put into the one table "Users".
Then for the 3 phase views under the ASPRunner "Create Login Page" set as follows,
Table: = Users

Username Field: = User_ID

Password Field: = Password
And under the "Advanced Security Settings" the different "Phase" data entry for each view was set as:
Users can see other user's data; can edit their own data only,

Users Table: OwnerID Field: = User_id

Main Table: OwnerID Field: = P1Rep

Main Table: OwnerID Field: = P2Rep

Main Table: OwnerID Field: = P3Rep
For the Admin edit all view,
Table: = Users

Username Field: = User_ID

Password Field: = Password
And under the "Advanced Security Settings"

Users Table: OwnerID Field: = Password Main Table: OwnerID Field: = admin (with the field set with the same value for each record resulting in a login that reacts like a hard coded login)
After the Build of this test project with 5.1, the results (although not ideal) were usable. When logged in as a phase 1 to 3 data personnel - they could view the "edit all" but they would not see "edit" as it did not appear on the list. Where as when logged in as admin, admin could edit / change everything from the "edit all view" and they could only view the phase 1 to 3 views.
Finally the problem with the build from 5.2. - Compiling / building the same project above results in the "edit" being visible in "edit all view" when logged in as phase 1 to 3 user! However, if it is clicked on nothing happens, but why is it their at all?
J
 		Jane 5/5/2008

Hi,
first static permissions work the same way in both ASPRunnerPro 5.1 and 5.2.
I recommend you to use one view for users and another view for admin.

Select Users can see and edit their own records only for users view and choose correct OwnerID fields. Then select Users can see and edit other users data security method for admin view, create admin group on the User group permissions dialog on the Security tab and set up full permissions for this view for admin group.

Also you can check different security settings in the "How to use security settings" tutorial here:

http://www.xlinesoft.com/asprunnerpro/tutorial.htm
X
 		xitedaz author 5/5/2008

Hi,

first static permissions work the same way in both ASPRunnerPro 5.1 and 5.2.
I recommend you to use one view for users and another view for admin.

Select Users can see and edit their own records only for users view and choose correct OwnerID fields. Then select Users can see and edit other users data security method for admin view, create admin group on the User group permissions dialog on the Security tab and set up full permissions for this view for admin group.

Also you can check different security settings in the "How to use security settings" tutorial here:

http://www.xlinesoft.com/asprunnerpro/tutorial.htm


I apologize for not being clear. I have created several diff views of which there are: Admin, Phase1, Phase2, & Phase3 - all of the views are working with the main table "Property". However, from the trial download (it seems), if you change the table for one view - it changes the table for all the views, unless of course, I am doing something wrong or just simply do not understand the program. I have went through the tutorials several times. Obviously I am missing something - I have also tried the dynamic permissions and cannot seem to get them to function correctly either.
FYI - In the program I wrote in ASP I use a table for Admin, a table for users, a table for managers, and a table for guests and also set security permissions. The reason I am willing to buy this program is simply it looks nicer & ASPRunner has output features I don't have time or desire to write, like export, import etc. If I am going to buy it, I would like to make it work without having to trace thru each function to find out where the problem is. Thanks for your reply.
Sergey Kornilov admin 5/5/2008

if you change the table for one view - it changes the table for all the views,


What kind of change you talking about?
To speed up the process post your application to Demo Account (last screen in ASPRunnerPro) and send the URL to support@xlinesoft.com along with screenshots that explain the issue.