nuBuilder Forum

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

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.

Sounds good to me will try to get it working.
Thank you very much!