Trying User Grou Permisions

Alberto,
could you explain what does it mean "does not allow me to change it to GroupID"?

Sergey, Sorry my writing is confusing.
In the GroupId (Combo box) shows the UserId field as a selected field (from my users table) and does not allow me to select the GroupID field (from my users table).
Opps..., I just realized that there where more fields in the combo for selection. It seemed to me that there was only one field because when you click the combo to open it down shows only 1 line, but I was wrong. Sorry.
Know I can continue trying it. Thanks

<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=7433&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' /> Sergey, I have tested it and it is a very good feature. May be not possible for me to use it yet (because of my complex structure of dynamic main menu, that contains all the menu options of all projects created and combined together) but is very good, useful and needed.
Sergey, check the Access/Permissions for ASPRunner wih Added Table Views created on step 3-12. It seems that security feature is considered only for tables level but not for this new concept you have created as ASPRunner views of tables (Very useful feature by the way)

When you are defining user group permissions you list only "tables" and "user database views" but not "ASPRunner table views".

Alberto,
fixed in build 78.

Excelent, Thanks sergey... <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=7472&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' />

Sergey:
It seems to be working.
But when we go back to User Group Permissions, the GroupId Combo box does not show the previously selected field and instead it shows the last field in the list. Then I re-select the right field, ok everithing out, then go back and it still wrong.
When working with "+Add group" and with "Choose existing user group" the combo box shows weir values like "EYK" the Y is like a chinese sign.

There are about 20 of them at the begining, then it shows the value I entered to only 1 user and is repited so many times. There is only 1 user with a GroupID value in my database table the rest users are empty in groupid field.
Anyways I did the test and the menu options are shown apparently ok.

Alberto,
I wasn't able to reproduce this.
Please send me your project file, your database and a couple of screenshots that explain what's happening.

Sergey,

I have just installed the 4.0 ( build 78) and I am experiencing some of the same issues with using security groups. I use MS Access (2000) database queries for the objects and have a Users table in my database. In step 9 when I use the Advanced Security feature and User Group permissions the [Group ID] combo box has multiple values, but the value selected is not retained when you come back into that interface. The outcome of this, I think, is that only the user that I designate as the admin user is able to see the available links on the menu.asp page. If one tries to access the ASP pages that they have been given rights to via groups the message "You don't have permission to access this table ...." is displayed. Other posts seem to indicate taht you can tweak this manually, which I am willing to do, but I wasn't sure what version those posts referred to. Any help appreciated.
Dave

Sergey, I just sent you and e-mail to support@xlinesoft.com as follows:
Alberto Salazar wrote:

Date: Thu, 12 Jan 2006 10:27:59 -0800 (PST)

From: Alberto Salazar

Subject: RE:Trying User Grou Permisions, ASPRunner Pro 4.0 TOPIC 2278

To: support@xlinesoft.com
Sergey, Please find screen shoots attached.
ScreenShot1: Shows the last field in the list is selected.

Screenshot2: Shows the it corrected and the beginning of the list of supossed existing user group in my database table.

ScreenShot3: Shows the end of the list .
In my test user table I have now lot of users but only 6 of them have a value in GroupID field as follows. Copare it with the screen shots.

si

yop

tu

HisGroup

YourGroup

MyGroup
Alberto B. Salazar

Sergey,

Sergey,

I was able to find a workaround for the issue. For now I have created a custom template and edited the login.asp. I replaced the "##USERGROUPFIELD##" keyword with the name of the field in my database that I know contains the group membership settings.
So Session("GroupID") = rs("<my group field>")
I could see by doing some response.write statements that it thought the Session("GroupID") was my username. I realize this is only a workaround but maybe it will help someone <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=7512&image=1&table=forumreplies' class='bbc_emoticon' alt=':unsure:' /> until 4.0.79 .
Cheers,
Dave

Dave,
this was fixed in build 79.