Record Level Security: Limiting Access Of Only Some Users

[CaitlinEnsley]

I am currently working on a search page where database users can search for their own records, view, and make edits if necessary. I was to restrict access of 4 of my users to only their own records. However, 3 users need to be able to access all records through the search form. 

 

I am having trouble thinking of a way to restrict access of only some users using record level security. Can anyone provide any guidance to how I might go about doing this?

 

Thanks! 

[LWSChad]

Two DataPages. One with RLS and one without.

 

Redirect users based on permission level.

 

Authentication table - tblUsers - accessAll - Yes/No

 

<script>
if("[@authfield:tblUser_accessAll^]" == "Yes"){
window.location = "[@app:managerPage]";
}


else{
window.location = "[@app:nonManagerPage]";
}
</script>

[astroboy]

Hi there! In case anyone has the same workflow, there is actually a HowTo article regarding User-Specific Redirection Upon Login which you can check in this link:

https://howto.caspio.com/tech-tips-and-articles/common-customizations/create-user-specific-redirect-after-login/

Cheers!