2. ASPRunnerPro General questions
  3. Active Directory And Advanced Security
This topic is locked

Active Directory And Advanced Security

 		1/21/2013 3:11:02 PM
ASPRunnerPro General questions
T
 Tim author

Hello,
I am using Active Directory integration for security, with IIS auto logon. It is working great, and I can print the Session("UserID") to the page and see that it is correctly grabbing the Windows login name. But I have attempted to setup a table with "advanced" security and set users to see and edit their own only. It asks for a field in the table to save the username to, which I have: feildname = UserName nvarchar(250). But nothing gets written to that field. Am I missing something? What data type should the username field be?
Thanks,

Tim
Sergey Kornilov admin 1/21/2013

Tim,
my suggestion is to use ASPRunnerPro Enterprise Edition 7.1 or 7.2 where Active Directory support is integrated and you can use Advanced Security features like 'Users can see and edit their own data only'.
T
 		Tim author 1/21/2013

That is what I'm using. That's why I'm coming to this forum when it's not being written to the table <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=69437&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' /> I'm not sure how to troubleshoot any further because it's kind of "built in".
Thanks for your quick reply.
Sergey Kornilov admin 1/22/2013

I guess you need to contact support directly providing a way to reproduce this issue.
G
 		gdmacdo 1/22/2013

Create a field in your table called "user" or something like that. You can delete the field from the add page through the editor (if you do not want it displayed).
On the event "Before Record Added", put the following statement:
values("user")=session("username")
Then, on the Security page, you would set the "Field to save username in" to the "user" field you created above.



That is what I'm using. That's why I'm coming to this forum when it's not being written to the table <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=69454&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' /> I'm not sure how to troubleshoot any further because it's kind of "built in".
Thanks for your quick reply.
T
 		Tim author 1/22/2013

Of course! Thanks Greg. I guess I assumed ASPRunner would write the username to that field by default because the setup page of the Advanced securities says "Field to save username in". I thought it wanted to know where to do it and then it would do it. But of course, I do it and this setup is just so it knows who owns the record, just like it was before AD integration.
I believe I should use Session("UserID") instead of Session("UserName") though. I'll test.
Thanks!

Tim
G
 		gdmacdo 1/22/2013

So sorry, yes - username



Of course! Thanks Greg. I guess I assumed ASPRunner would write the username to that field by default because the setup page of the Advanced securities says "Field to save username in". I thought it wanted to know where to do it and then it would do it. But of course, I do it and this setup is just so it knows who owns the record, just like it was before AD integration.
I believe I should use Session("UserID") instead of Session("UserName") though. I'll test.
Thanks!

Tim