Hi Guys,
I was wondering, is it possible to provide access to some information within a MySQL DB based on the login of a company? So instead of controlling only the access of forms and reports. For example I would like to setup an application as a portal so multiple companies will have access to the application (same forms and reports) but are only able to see and access their own data.
Please let me know if you have any questions.
Thank you for your help!
Cheers,
Fred
Welcome to the nuBuilder Forums!
Register and log in to access exclusive forums and content available only to registered users.
Register and log in to access exclusive forums and content available only to registered users.
Grant access based on a company name
-
kev1n
- nuBuilder Team
- Posts: 4305
- Joined: Sun Oct 14, 2018 6:43 pm
- Has thanked: 71 times
- Been thanked: 446 times
- Contact:
Re: Grant access based on a company name
Hi Fred,
First, create different Access Levels for each company. Then, when a record is saved, also store the Access Level Id of the user. By doing so, you can add a WHERE clause to a form's Browse SQL to filter out records that do not belong to that Access Level/company.
Use Hash Cookies in the SQL.
First, create different Access Levels for each company. Then, when a record is saved, also store the Access Level Id of the user. By doing so, you can add a WHERE clause to a form's Browse SQL to filter out records that do not belong to that Access Level/company.
Use Hash Cookies in the SQL.
-
MrFast
- Posts: 6
- Joined: Mon Aug 09, 2021 9:35 am
Re: Grant access based on a company name
Sounds good to me 
will try to get it working.
Thank you very much!
will try to get it working.Thank you very much!