2. ASPRunnerPro General questions
  3. Security Question
This topic is locked

Security Question

 		9/15/2007 11:01:58
ASPRunnerPro General questions
Y
 yairilan author

Hello,

I have a table of people with ID field, Group Id field, username etc...

I've choose option 2 in the "Advanced security settings" - and every user who loggs-in can see and edit his own group

Is there an option to let the group see thier Data but let only the person who loggs-In to edit his data only? Thanks very much - I hope it's understood,

Yair <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=6248&image=1&table=forumtopics' class='bbc_emoticon' alt=':unsure:' />
Sergey Kornilov admin 9/16/2007

Sure, you need to choose another Advanced Security option "Users can see all data, can edit their own data only".
Y
 		yairilan author 9/16/2007

Sure, you need to choose another Advanced Security option "Users can see all data, can edit their own data only".


Thanks,

I've tried it,but I don't want the user to see all the data. I want him to see only the group he belongs to, and edit only his row.

The best way to do it, as I see it, is to choose the 2nd option ( in which user can see and edit all the rows he can see), and to make the "edit" botton available only for the user's data row.

Is it possible?
Sergey Kornilov admin 9/16/2007

Yair,
yes, you can use "Users can see all data, can edit their own data only" security mode and BeforeSQLQuery event to restrict users from seeing other groups data.
It all depends on your database structure. Contact me personally for more details.