Help get this topic noticed by sharing it on Twitter, Facebook, or email.

Restricting User Access To Data based on User rights

Hi,

with the below link we can restrict the user data.

https://www.youtube.com/watch?v=Ok1eP...

but its having creator and owner field.

with creator column on insert task automatically get the user and saved into database with below code
set @Creator=@BusinessRules_UserName

as showed in attached image (BusinessRule-Insert.png)

How can filter based on ASP.net membership.

If user has administrator then can see all task, and if the user has role is user then only shows the task what they/user enter.

How to do it in filter as shown in attached CreateFilter.png.
Filter expression is given below.

Creator=@BusinessRules_UserName

with above only shows what they insert the record.

example:

if Role=Administrator then
"SHOW ALL TASK/RECORDS"
else
"SHOW ONLY THAT RECORD/TASK WHICH HE CREATED"
END

Thanks
Basit.
1 person has
this question
+1
Reply